我需要?jiǎng)h除字符串列表：list_strings=['describe','include','any']來(lái)自 pandas 的專欄：My_Columninclude details about your goaldescribe expected and actual resultsshow some code anywhere我試過(guò)df['My_Column']=df['My_Column'].str.replace('|'.join(list_strings), '')但它刪除了部分單詞。例如：My_Columndetails about your goalexpected and actual resultsshow some code where # here it should be anywhere我的預(yù)期輸出：My_Columndetails about your goalexpected and actual resultsshow some code anywhere
3 回答
慕姐4208626
TA貢獻(xiàn)1852條經(jīng)驗(yàn) 獲得超7個(gè)贊
使用“詞邊界”\b之類的表達(dá)方式。
In [46]: df.My_Column.str.replace(r'\b{}\b'.format('|'.join(list_strings)), '')
Out[46]:
0 details about your goal
1 expected and actual results
2 show some code anywhere
Name: My_Column, dtype: object
慕的地6264312
TA貢獻(xiàn)1817條經(jīng)驗(yàn) 獲得超6個(gè)贊
您的問(wèn)題是pandas看不到單詞，它只看到字符列表。因此，當(dāng)你要求 pandas 刪除“any”時(shí)，它并不是從描繪單詞開(kāi)始的。所以一種選擇是你自己做，也許是這樣的：
# Your data
df = pd.DataFrame({'My_Column':
['Include details about your goal',
'Describe expected and actual results',
'Show some code anywhere']})
list_strings=['describe','include','any'] # make sure it's lower case
def remove_words(s):
if s is not None:
return ' '.join(x for x in s.split() if x.lower() not in list_strings)
# Apply the function to your column
df.My_Column = df.My_Column.map(remove_words)
慕神8447489
TA貢獻(xiàn)1780條經(jīng)驗(yàn) 獲得超1個(gè)贊
方法的第一個(gè)參數(shù).str.replace()必須是字符串或編譯后的正則表達(dá)式；不是像你這樣的列表。
你可能想要
list_strings=['Describe','Include','any'] # Note capital D and capital I
for s in [f"\\b{s}\\b" for s in list_strings]: # surrounded word boundaries (\b)
df['My_Column'] = df['My_Column'].str.replace(s, '')
獲得
My_Column
0 details about your goal
1 expected and actual results
2 Show some code anywhere
添加回答
舉報(bào)
0/150
提交
取消