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

0 vote252 views1 answer
Lucky four codechef solution
Python
0 vote245 views1 answer
How to get parent model object based on child model filter in django
Python
134 votes245 views6 answers
Rename columns pandas
Python
12 votes237 views3 answers
Rstrip in python
Python
1 vote218 views1 answer
Subset a list python
Python
0 vote240 views1 answer
Xmlrpc get all posts
Python
0 vote237 views1 answer
Credential not provided when i try to sign up a new user django
Python
15 votes231 views6 answers
How to get confusion matrix in python
Python
0 vote239 views1 answer
How to make curl request python
Python
0 vote236 views1 answer
SimpleITK interpolation
Python