我試圖在 csv 檔案中搜索關鍵字，但現在我什至找不到一個字串，這就是我正在做的任何解決方案我將 csv 轉換為 pandas 資料幀我想向資料幀添加一個 id=ndication 就像一個檢查或運行計數
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)
uj5u.com熱心網友回復：
這取決于您是否只想在一列中過濾：
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
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/495894.html