How to exclude rows in one dataframe column from another dataframe

Asked Mar 08 '20 at 13:25

Active Mar 08 '20 at 13:28

Viewed 19 times

I tried the code snippet below but that results in a new two columns Datframe.

df_foo.join(df_bar, on="id", who="left")

edited Mar 08 '20 at 13:28

asked Mar 08 '20 at 13:25

XY L

2

How about `df1[~df1['ID'].isin(df2['ID'])]` ? or `df1.merge(df2,on='id',how='outer', suffixes=('','_'),indicator=True).query('_merge == "left_only"')` – anky Mar 08 '20 at 13:27
2

Or just `reindex`: `df_foo.merge(df_bar, on="id", how="left", suffixes=('', '_y')).reindex(columns=df_foo.columns)` – Chris Adams Mar 08 '20 at 13:30

0 Answers0