我有两个数据帧,我需要在其中映射关键字。 输入数据(df1)如下所示:
keyword subtopic
post office Brand
uspshelp uspshelp Help
package delivery Shipping
fed ex Brand
ups fedex Brand
delivery done Shipping
united states location
rt ups retweet
这是用于关键字匹配的另一个数据帧(df2):
Key Media_type cleaned_text
910040 facebook will take post office
409535 twitter need help with upshelp upshelp
218658 facebook there no section post office alabama ups fedex
218658 facebook there no section post office alabama ups fedex
518903 twitter cant wait see exactly ups fedex truck package
2423281 twitter fed ex messed seedless
763587 twitter crazy package delivery rammed car
827572 twitter formatting idead delivery done
2404106 facebook supoused mexico united states america
1077739 twitter rt ups
我想根据以下几个条件将df1中的“关键字”列映射到df2中的“已清理文本”列:
这是输出数据帧(df3)的外观:
Key Media_type cleaned_text keyword subtopic
910040 facebook will take post office post office Brand
409535 twitter need help with upshelp upshelp uspshelp uspshelp Help
218658 facebook there no section post office alabama ups fedex post office Brand
218658 facebook there no section post office alabama ups fedex ups fedex Brand
518903 twitter cant wait see exactly ups fedex truck package ups fedex Brand
2423281 twitter fed ex messed seedless fed ex messed Brand
763587 twitter crazy package delivery rammed car package delivery Shipping
827572 twitter formatting idead delivery done delivery done Shipping
2404106 facebook supoused mexico united states america united states america location
1077739 twitter rt ups rt ups retweet
把df1转换成字典怎么样?然后在df2中循环并搜索匹配项。这也许不是最有效的方法,但它可读性很强
相关问题 更多 >
编程相关推荐