/Python/Pandas merge query "_merge='left_only'"

Pandas merge query "_merge='left_only'"

d = (
    df1.merge(df2, 
              on=['c', 'l'],
              how='left', 
              indicator=True)
    .query('_merge == "left_only"')
    .drop(columns='_merge')
)

print(d)
   c  k  l
0  A  1  a
2  B  2  a
4  C  2  d

Source: stackoverflow.com

Similar codes

23 votes171 views4 answers
Python flat list from list of list
Python
0 vote161 views1 answer
Binary to decimal python
Python
0 vote162 views1 answer
Python argsort a list
Python
17 votes159 views5 answers
ModuleNotFoundError: No module named 'tkinter'
Python
5 votes169 views2 answers
Make image fit to size tkinter
Python
0 vote171 views2 answers
How to split string with comma in python
Python
3 votes195 views2 answers
Python extract specific columns from pandas dataframe
Python
2 votes279 views1 answer
Average within group by pandas
Python
0 vote160 views1 answer
Is plaindrome python
Python
0 vote172 views1 answer
How to navigate to a sub html script selenium python
Python