/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 vote264 views1 answer
All subarrays of an array python
Python
88 votes268 views6 answers
How to check python version
Python
47 votes243 views9 answers
Cannot be loaded because running scripts is disabled on this system
Python
0 vote257 views1 answer
Sqlalchemy filter between dates
Python
3 votes264 views3 answers
Close a file python
Python
0 vote267 views1 answer
Np array blurring
Python
21 votes264 views5 answers
Base64 decode python
Python
23 votes306 views4 answers
Pandas show all rows
Python
89 votes248 views6 answers
Requirements.txt python
Python
2 votes259 views1 answer
Binomial coefficient python
Python