我有一個包含聊天資訊的文本列,我想傳入一個單詞串列,如果它們出現在該文本列中,如果單詞沒有出現,則會將錯誤列修改為 1 和 0:
chatid text card_declined booking_error website_error
401 hi my card declined.. 0 0 0
402 you website crashed.. 0 0 0
403 hi my card declined.. 0 0 0
for example
carddeclined = ['card declined', 'Card error']
for i in df[df['textchat'].str.contains('|'.join(carddeclined),na=False)]:
df['card declined'] = 1
This currently just returns all card declined rows with 1
uj5u.com熱心網友回復:
您可以將轉換后的布爾系列分配給整數,因為串列中的一些大寫值被添加到case=False引數中Series.str.contains:
carddeclined = ['card declined', 'Card error']
df['card_declined'] = df['text'].str.contains('|'.join(carddeclined),
na=False,
case=False).astype(int)
print (df)
chatid text card_declined booking_error website_error
0 401 hi my card declined.. 1 0 0
1 402 you website crashed.. 0 0 0
2 403 hi my card declined.. 1 0 0
轉載請註明出處,本文鏈接:https://www.uj5u.com/qukuanlian/463803.html
上一篇:將字典轉換為熊貓資料框?
