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

1 vote141 views1 answer
How to save an image with the same name after editing in python pillow module
Python
0 vote146 views2 answers
Doormat pattern python
Python
0 vote134 views6 answers
How to choose a random key from a dictionary in python
Python
0 vote147 views1 answer
Selenium proxy with authentication
Python
1 vote139 views2 answers
Python remove dict key/values
Python
0 vote159 views1 answer
Extract year from astype('datetime64[ns]')
Python
0 vote154 views2 answers
Python datetime to seconds
Python
0 vote147 views1 answer
Python string: .strip()
Python
15 votes145 views3 answers
Python random text generator
Python
0 vote145 views1 answer
Num = [7,8, 120, 25, 44, 20, 27] newnum = [] def remove_even(num): for i in num: if i%2 != 0: newnum.append(i) return newnum print("get_unevens") test(remove_even(num), [7,25,27])
Python