Filter one dataframe by another

df1 = pd.DataFrame({'c': ['A', 'A', 'B', 'C', 'C'],
                    'k': [1, 2, 2, 2, 2],
                    'l': ['a', 'b', 'a', 'a', 'd']})
df2 = pd.DataFrame({'c': ['A', 'C'],
                    'l': ['b', 'a']})
keys = list(df2.columns.values)
i1 = df1.set_index(keys).index
i2 = df2.set_index(keys).index
df1[~i1.isin(i2)]

Source: stackoverflow.com

Similar codes

7 votes318 views2 answers
How to generate requirements.txt django
Python
0 vote312 views3 answers
Boto3 python s3
Python
0 vote312 views1 answer
If number Of Players == >=4 python
Python
1 vote303 views3 answers
Check cuda version pytorch
Python
0 vote304 views1 answer
Plt.clear
Python
1 vote290 views1 answer
Numpy isinstance
Python
0 vote298 views1 answer
Dataframe rank groupby
Python
2 votes275 views2 answers
Spacy frenc hlemmatizer
Python
0 vote291 views1 answer
Remove multiple strings from list python
Python
4 votes327 views1 answer
Dataframe to csv without ids
Python