Drop rows from pandas dataframe

Question

I need to drop some rows from a pandas dataframe aa based on a query as follows:

aa.loc[(aa['_merge'] == 'right_only') & (aa['Context Interpretation'] == 'Topsoil')]

How do I drop this selection from the datafram aa?

BENY · Accepted Answer · 2020-11-23 14:44:04Z

1

You can do add '~'

out = aa.loc[~((aa['_merge'] == 'right_only') & (aa['Context Interpretation'] == 'Topsoil'))]

Or

idx = aa.index[(aa['_merge'] == 'right_only') & (aa['Context Interpretation'] == 'Topsoil')]
out = aa.drop(idx)

answered Nov 23, 2020 at 14:44

BENY

324k22 gold badges176 silver badges250 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

So that's what the tilde does!