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

13 votes213 views3 answers
Hstack in numpy
Python
0 vote196 views1 answer
Pyplot new figure
Python
0 vote232 views1 answer
Inverted trapezium pattern in python
Python
0 vote208 views1 answer
Python diferente de
Python
0 vote204 views1 answer
Line continutation in r string python
Python
0 vote212 views1 answer
No module named 'deeppavlov.skills.pattern_matching_skill'
Python
-1 vote221 views1 answer
How to check if string ends with specific characters in python
Python
2 votes317 views1 answer
Get dictionary in array python by value
Python
0 vote196 views4 answers
Dataframe to dict without index
Python
26 votes191 views1 answer
Shutil move file
Python