/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

0 vote167 views1 answer
Keyboard input raspberry pi
Python
0 vote188 views1 answer
Remove percentage in python
Python
2 votes191 views2 answers
Python greatest common divisor
Python
4 votes265 views1 answer
Finding a substring between 2 strings
Python
18 votes298 views3 answers
Django-admin startproject
Python Django
4 votes188 views1 answer
Orderd set in python
Python
0 vote257 views1 answer
How to change the size of datapoint in plot python
Python
0 vote177 views1 answer
What does it mean when i get a permission error in python
Python
0 vote266 views1 answer
Python youtube downloader (Downloading multiple videos)
Python
0 vote181 views1 answer
How to send jobs to queue dynamically
Python