/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

29 votes137 views5 answers
List comprehension python if else
Python
2 votes208 views1 answer
Finding if user input is lower or upper in python
Python
0 vote177 views2 answers
How to feature selection in python
Python
26 votes175 views4 answers
Python send email with attachment
Python
0 vote200 views1 answer
I want to add a new column to the DataFrame containing only the month of the measurement
Python
1 vote157 views1 answer
Python index where true
Python
13 votes142 views3 answers
How to split text into list python by characters
Python
0 vote139 views1 answer
Ffmpeg python get total frames
Python
-1 vote144 views1 answer
Show dataframe pandas python
Python
2 votes148 views3 answers
List inside a list in python
Python