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 vote170 views1 answer
Geopandas plot fullscreen
Python
3 votes196 views1 answer
How do you print a integer in python
Python
12 votes185 views4 answers
Pytesseract.pytesseract.TesseractError: (2, 'Usage: pytesseract [-l lang] input_file')
Python
7 votes157 views6 answers
Tensorflow version check
Python
23 votes177 views1 answer
Python get minute from datetime
Python
1 vote184 views1 answer
List methods in python
Python
2 votes163 views2 answers
Instance variable in python
Python
2 votes196 views2 answers
Write object to file python
Python
1 vote185 views1 answer
Pd count how many item occurs in another column
Python
3 votes142 views1 answer
Time decorator python
Python