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 vote188 views1 answer
If condition python with index
Python
16 votes172 views1 answer
Classes in python with self parameter
Python
5 votes187 views1 answer
Window size cv2
Python
0 vote208 views1 answer
Pathlib check is file
Python
0 vote198 views2 answers
Get min of list python
Python
2 votes191 views3 answers
Get webpage data as json python
Python
7 votes191 views2 answers
Python string to datetime python
Python
0 vote197 views1 answer
How to read docx file in python
Python
1 vote201 views2 answers
Python delete attribute from dict
Python
2 votes193 views1 answer
Python string formatting escape curly brace
Python