我有一個像這樣的數據框：Source | Description |Incomes | Tax 12 |Incomes | Payment |Incomes | Check 152 |Incomes | Incoming 21 |Incomes | Receiving |Payments | Tax |Payments | Incoming 7 |Payments | Receiving 12 |Payments | Check |Payments | Incoming |首先，我替換所有包含IncomingorCheck和using的內容：IncomesCheckdf.locSource | Description |Incomes | Incomes |Incomes | Payment |Incomes | Checks |Incomes | Incomes |Incomes | Receiving |Payments | Receiving 2 |Payments | Incomes |Payments | Receiving 12 |Payments | Checks |Payments | Incomes |現在我想用相應的值替換與列不匹配Incomes或 不匹配的所有內容，如下所示：ChecksDesciptionSourceSource | Description |Incomes | Incomes |Incomes | Incomes |Incomes | Checks |Incomes | Incomes |Incomes | Incomes |Payments | Payments |Payments | Incomes |Payments | Payments |Payments | Checks |Payments | Incomes |我該怎么做？我已經嘗試df.loc[df['Description'].str.contains('Incomes|Checks')== False] == df['Source']過但沒有成功。提前致謝
1 回答
慕的地8271018
TA貢獻1796條經驗 獲得超4個贊
用這個，
mask = df['Description'].str.contains("Incoming|Check")
df.loc[~mask, "Description"] = df.loc[~mask, "Source"]
df['Description'] = df['Description'].str.replace("Incoming.*", "Incomes") \
.str.replace("Check.*", "Checks")
添加回答
舉報
0/150
提交
取消