搜索大熊猫数据在python中寻找关键词
搜索大熊猫数据在python中寻找关键词
提问于 2022-06-25 19:52:22
我试图在csv文件中搜索关键字，但现在我甚至找不到一个字符串，这是我正在做的任何解决方案，我将csv转换成一个熊猫数据，我想像检查或运行计数一样将id=ndication添加到dataframe中
import pandas as pd
import numpy as np
df = pd.read_csv('InventoryValue-byItem-6-25-22.csv')
df.apply(lambda columns: columns.astype(str).str.contains("VODKA").any(), axis=1)
df.to_csv('file_name.csv', index=False)回答 1
Stack Overflow用户
回答已采纳
发布于 2022-06-25 20:11:02
这取决于您是否只希望在一列中进行筛选：
import pandas as pd
data={'number':np.random.uniform(0,20,size=5),'text1':["test VODKA","test","Nothing","Something","VODKA Orange"], 'text2':["no","VODKA sprite","yes","yes","no"] }
df=pd.DataFrame(data)
#If you are only looking in one column:
#cast the column as string...
df['text1'].astype(str)
print(df[df['text1'].astype(str).str.contains("VODKA",case=False)])结果：
number text1 text2
0 17.505103 test VODKA no
4 17.585175 VODKA Orange no或在所有栏中：
import pandas as pd
data={'number':np.random.uniform(0,20,size=5),'text1':["test VODKA","test","Nothing","Something","VODKA Orange"], 'text2':["no","VODKA sprite","yes","yes","VODKA Orange"] }
df=pd.DataFrame(data)
#to look in all columns
dfFinal=pd.DataFrame()
for column in df.columns:
dfTemp=df[df[column].astype(str).str.contains("VODKA",case=False)]
dfFinal=dfFinal.append(dfTemp)
dfFinal.drop_duplicates(inplace=True)
print(dfFinal)结果：
number text1 text2
0 4.690792 test VODKA no
4 8.835689 VODKA Orange VODKA Orange
1 17.707329 test VODKA sprite页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/72756946
复制相关文章
相似问题
腾讯云开发者
