/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 vote325 views1 answer
Store message sent by user in string discord py
Python
0 vote326 views1 answer
How to know if the space button has been clicked in python pygame
Python
0 vote342 views1 answer
How to type using selenium python
Python
1 vote403 views1 answer
Get a list of open applications python
Python
41 votes360 views6 answers
Python comments
Python
0 vote415 views1 answer
Flask mongoengine getting started
Python Flask
2 votes347 views2 answers
Write object to file python
Python
5 votes363 views6 answers
Matplotlib subplots
Python
0 vote368 views1 answer
Matplotlib: use colormaps for line plot colors
Python
0 vote337 views1 answer
Python how to change a point in a multidimensional list
Python