/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

25 votes232 views6 answers
Pickle python
Python
10 votes252 views4 answers
How to know if python is 64 or 32 bit
Python
10 votes216 views3 answers
Set value based on column
Python
0 vote195 views1 answer
Z-score
Python
1 vote184 views2 answers
Python dataframe remove header
Python
6 votes215 views4 answers
What is a python module
Python
2 votes195 views1 answer
How to return a value from a function in python
Python
10 votes179 views3 answers
Python print traceback from exception
Python
58 votes180 views6 answers
Matplotlib plot
Python
24 votes203 views6 answers
How to save a pickle file
Python