/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

3 votes237 views3 answers
How to insert image in python
Python
1 vote236 views1 answer
Cut 0s on string python
Python
0 vote275 views3 answers
Generate binay image python
Python
0 vote241 views1 answer
Python csv find specific string
Python
1 vote239 views1 answer
Handler.setLevel(logging.DEBUG) not working python
Python
0 vote195 views1 answer
Read a png file in python
Python
12 votes247 views6 answers
How to merge two dictionaries in python
Python
0 vote255 views1 answer
Django filter word count greater than
Python
0 vote222 views1 answer
Convert list to tree python
Python
2 votes246 views1 answer
Max of matrix numpy
Python