/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

2 votes126 views4 answers
Python switch
Python
2 votes118 views1 answer
Python subtract 2 strings
Python
0 vote126 views1 answer
How to import a all the modules in a packege python
Python
2 votes129 views1 answer
Matplotlib 3D plots reduce margins
Python
19 votes116 views4 answers
Convert column series to datetime in pandas dataframe
Python
1 vote127 views1 answer
Ursina python
Python
17 votes129 views5 answers
Python input integer
Python
0 vote121 views1 answer
List Method: list append vs extend
Python
0 vote85 views1 answer
Python main.py
Python
0 vote86 views1 answer
Python convert dcm to png
Python