/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

27 votes95 views4 answers
How to do a square root in python
Python
1 vote105 views1 answer
Python roll a die
Python
91 votes99 views5 answers
How to delete file in python
Python
0 vote119 views1 answer
This figure includes axes that are not compatible with tight_layout, so results might be incorrect
Python
0 vote99 views1 answer
Python last element of list using reverse() function
Python
4 votes122 views4 answers
Count unique elements in list python
Python
0 vote99 views1 answer
Django save object in view
Python
0 vote122 views1 answer
Save changes flask sqlalchemy
Python
9 votes113 views6 answers
How to get timezone in python
Python
-1 vote109 views3 answers
Play Video in Google Colab
Python