/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

4 votes202 views3 answers
Python fibbonacci
Python
2 votes451 views1 answer
Minimal flask application import
Python Flask
1 vote200 views1 answer
Vector in python
Python
29 votes232 views3 answers
Print python float precision
Python
-1 vote181 views1 answer
Usage code grepper
Python
62 votes208 views6 answers
Python loop with index
Python
0 vote210 views1 answer
Super().__init__(pos, model) in python
Python
8 votes186 views1 answer
Expand all rows pandas
Python
2 votes231 views1 answer
Django create model from dictionary
Python Django
1 vote227 views1 answer
Last 24 hour python datetime
Python