我有两个数据帧需要合并。第一个是:
page value
shoes 554
sneakers 226
sandals 114
boots 821
T-shirt 213
mobile-phone 284
laptop 361
第二个数据帧是:
path1 path2 path3 path4
fashion footwear shoes-and-other shoes
fashion footwear shoes-and-other sneakers
fashion footwear sandals NaN
fashion footwear shirts T-shirt
electronic devices mobile-and-tablet mobile-phone
electronic devices laptop NaN
我的预期产出将是:
path1 path2 path3 path4 page value
fashion footwear shoes-and-other shoes shoes 554
fashion footwear shoes-and-other sneakers sneakers 226
fashion footwear sandals NaN sandals 114
fashion footwear shirts T-shirt T-shirt 213
electronic devices mobile-and-tablet mobile-phone mobile-phone 284
electronic devices laptop NaN laptop 361
如果第一个数据帧中的任何page
字符串存在于第二个数据帧的path1
或path2
或path3
或path4
列中,我想连接这两个数据帧。请注意,第一个数据帧的page
可能与第二个数据帧的path1
匹配,我有多种情况
有一种简单的肾盂疗法吗
让我们尝试
where
使用ffill
创建合并键,然后merge
相关问题 更多 >
编程相关推荐