/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

0 vote285 views1 answer
Pandas df count values less than 0
Python
136 votes316 views6 answers
How to take input in python
Python
0 vote290 views1 answer
Total keywords in python
Python
1 vote272 views3 answers
Count function in python
Python
17 votes274 views5 answers
Convert numpy array to tensor
Python
0 vote262 views1 answer
Django.db.backends.mysql install
Python
0 vote294 views1 answer
Plot bar chart python with resulting numbers
Python
3 votes312 views2 answers
Pandas normalize columns
Python
0 vote269 views1 answer
Sentiment analysis french python
Python
11 votes280 views2 answers
That does 1:to:3 do Python ?
Python