/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

8 votes228 views1 answer
Python find runtime
Python
4 votes228 views1 answer
Django objects.create()
Python
0 vote262 views1 answer
Scatter matrix plot
Python
0 vote234 views1 answer
Convert the sklearn.dataset cancer to a DataFrame.
Python
23 votes257 views6 answers
Odd or even python
Python
0 vote239 views1 answer
All alphabets
Python
0 vote245 views1 answer
Print python setencode
Python
0 vote253 views1 answer
Longest Palindromic Substring using DP
Python
0 vote267 views1 answer
Plotly ylog
Python
1 vote239 views2 answers
If condition in print statement python
Python