嗨，我有 2 個資料框，但兩者都不相同。我必須根據第二個更新一個。
示例：df1：
Region Sub_Region Run_Date Status Reason
ASPAC CRM 2022-01-11 Success
ASPAC Genesys 2022-01-11 Failed
LATAM CRM 2022-01-11 Success
df2:
Region Sub_Region Max_Load_Date
NA CRM 2021-08-12
ASPAC CRM 2021-03-15
LATAM CRM 2021-10-11
NA Genesys 2021-12-18
ASPAC Genesys 2021-11-18
LATAM Genesys 2021-04-16
在最終輸出中：
Region Sub_Region Run_Date Status Reason Max_Load_Date
ASPAC CRM 2022-01-11 Success 2021-03-15
ASPAC Genesys 2022-01-11 Failed
LATAM CRM 2022-01-11 Success 2021-10-11
df1 將在 status = 'Success' 時更新
uj5u.com熱心網友回復：
過濾掉你的資料框后merge：
df1['Max_Load_Date'] = df1.merge(df2, on=['Region', 'Sub_Region'], how='left') \
.query("Status == 'Success'")['Max_Load_Date']
print(df)
# Output
Region Sub_Region Run_Date Status Reason Max_Load_Date
0 ASPAC CRM 2022-01-11 Success NaN 2021-03-15
1 ASPAC Genesys 2022-01-11 Failed NaN NaN
2 LATAM CRM 2022-01-11 Success NaN 2021-10-11
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/408922.html
標籤：