/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

1 vote171 views1 answer
How to make a alert box in python
Python
19 votes163 views1 answer
Python string cut left
Python
0 vote173 views1 answer
Wx.SingleInstanceCheckerindexmodules
Python
0 vote162 views1 answer
How to find a website ip address
Python
1 vote171 views1 answer
Print upto 1 decimal place python
Python
25 votes173 views3 answers
Python warnings as error
Python
1 vote206 views1 answer
Django text area limit characters
Python
1 vote176 views2 answers
Pandas merge two columns from different dataframes
Python
1 vote223 views1 answer
Django add to cart
Python Django
42 votes169 views5 answers
Iterate array python with index
Python