/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

12 votes153 views1 answer
Make a zero list python
Python
0 vote165 views1 answer
Check pip installed packages inside virtualenv
Python
0 vote156 views1 answer
Supercharged python
Python
0 vote143 views1 answer
Obtenir coordonnees souris python
Python
1 vote140 views1 answer
Colab save figure
Python
0 vote133 views1 answer
Calculate time python
Python
0 vote149 views1 answer
Couldn't open showimage no such file or directory
Python
1 vote159 views2 answers
List all virtualenv in python
Python
0 vote148 views1 answer
Python save string to text
Python
2 votes134 views2 answers
Check string similarity python
Python