有了一个水果列表,我想检查它们是否存在于数据框中(不管是哪列),并指出它们。你知道吗
import pandas as pd
Fruits = ["Avocado", "Blackberry", "Black Sapote", "Fingered Citron", "Crab Apples", "Custard Apple", "Chico Fruit", "Coconut", "Damson", "Elderberry", "Goji Berry", "Grape", "Guava", "Huckleberry"]
data = {'ID': ["488", "14805", "23591", "470995", "56251", "85964", "5268", "322624", "342225", "380689", "480562", "5623"],
'Content' : ["Kalo Beruin", "this is Blackberry", "Khara Beruin", "guava and coconut", "Lapha", "Loha Sura", "Matichak", "Miniket Rice", "Mou Beruin", "Moulata", "oh Goji Berry", "purple Grape"],
'Content_1' : ["Jook-sing noodles", "grape", "Lai fun", "Damson", "Liangpi", "Custard Apple and Crab apples", "Misua", "nana Coconut Berry", "Damson", "Paomo", "Ramen", "Rice vermicelli"]}
df = pd.DataFrame(data)
df = df[['ID', 'Content', 'Content_1']]
s = pd.Series(data['Content'])
s_1 = pd.Series(data['Content_1'])
df["found_content"] = s[s.str.contains('|'.join(Fruits))]
df["found_content_1"] = s_1[s_1.str.contains('|'.join(Fruits))]
writer = pd.ExcelWriter('C:\\TEM\\22522.xlsx')
df.to_excel(writer,'Sheet1', index = False)
writer.save()
代码的问题是:
我怎样才能做到呢?非常感谢。你知道吗
以下是当前输出和所需输出的屏幕截图。你知道吗
使用^{} 和} 连接列表:
re.I
表示忽略大小写,然后按^{另一种解决方案是使用^{} 代替
re.I
:也许是这样:
相关问题 更多 >
编程相关推荐