How can I drop some values from a dataframe using another dataframe as parameter?
df1
code | reply
A1 | yes
A2 | yes
A3 | no
df2
code |
A1 |
A1 |
A3 |
df_new = df1.drop(df1['code'] == df2['code'] AND df1['reply'] != 'yes')
df_new
code | reply
A1 | yes
Is there a simple way to do this using .drop()?
>Solution :
Use boolean indexing:
out = df1[df1['code'].isin(df2['code']) & df1['reply'].eq('yes')]
Output:
code reply
0 A1 yes