删除常见的观察

Question

我有 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

               ]})#Netherlands

Map4 = 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']]

Answer 1

由于您只有 2 列，因此一个简单的解决方案可能是：common = (Map3.partner_country + Map3.my_network).isin(Map4.partner_country + Map4.my_network)Map3 = Map3.loc[~common]