/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

9 votes114 views2 answers
How to loop through lines python
Python
0 vote99 views1 answer
Pandas difference between subsequent lines
Python
1 vote116 views2 answers
Django drop database postgres
Python
6 votes104 views3 answers
Flask cors
Python
0 vote114 views1 answer
Custom attribute selenium
Python
3 votes107 views1 answer
Make a window tkinter
Python
0 vote75 views1 answer
Locate certificate path python
Python
3 votes133 views1 answer
Flask upload
Python Flask
4 votes167 views2 answers
How to find the last occurrence of a character in a string in python
Python
3 votes108 views1 answer
Python urlencode with requests
Python