我有 2 個數據框Map3 = pd.DataFrame({"partner_country": ["France","France","France","France","France","France", "Spain","Spain","Spain","Spain","Spain","Spain" ],"my_network": ["Ireland","Austria",None,"Sweden","Italy",None , #France "Ireland","Austria","Denmark","Sweden",None,"United Kingdom" #Spain ]})#NetherlandsMap4 = pd.DataFrame({"partner_country": ["France","France","France","France","France","France", "Spain","Spain","Spain","Spain","Spain","Spain" ],"my_network": [None,None,None,None,"Italy",None , #France None,"Austria",None,"Sweden",None,"United Kingdom" #Spain ]})#Netherlands我想從 Map3 數據框中刪除 Map3 和 Map4 中常見的所有觀察結果。嘗試了以下代碼：Map4[~(Map4['partner_country'].isin(Map3['partner_country'])Map4['my_network'].isin(Map3['my_network']]
1 回答
寶慕林4294392
TA貢獻2021條經驗 獲得超8個贊
由于您只有 2 列，因此一個簡單的解決方案可能是：
common = (Map3.partner_country + Map3.my_network).isin(Map4.partner_country + Map4.my_network)Map3 = Map3.loc[~common]
添加回答
舉報
0/150
提交
取消