/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 vote257 views1 answer
Unit converter idle python
Python
0 vote263 views1 answer
Qubesos
Python
0 vote242 views1 answer
Lims
Python
13 votes269 views5 answers
Finding the maximum value in a list python
Python
0 vote268 views1 answer
How to create a graphical user interface in python
Python
0 vote262 views1 answer
Matlab .* operator in python
Python
2 votes289 views1 answer
Version of scikit learn
Python
0 vote265 views1 answer
Python make string one line
Python
1 vote291 views1 answer
Django don't redirect on submission
Python Django
0 vote225 views1 answer
Left rotation in list
Python