/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 votes161 views1 answer
Tkinter label textvariable example
Python
0 vote184 views1 answer
Tkinter taille de l'ecran
Python
1 vote188 views1 answer
Insert data in django models
Python Django
-1 vote176 views3 answers
Count string python
Python
0 vote152 views1 answer
Improt kmean
Python
16 votes160 views6 answers
Map in python
Python
0 vote148 views1 answer
Split() vs split(' ')
Python
9 votes150 views2 answers
Python if value in range
Python
0 vote148 views1 answer
Pandas assign value to row based on condition
Python
1 vote178 views1 answer
Cannot import name 'candlestick2_ohlc
Python