delete column based on two conditions in a dataframe

Question

I am trying to delete column based on two conditions in a dataframe. I am trying to delete a column from a data frame and I wrote the following code

DATAFRAME= DATAFRAME.drop(DATAFRAME.loc[(DATAFRAME['COLUMN1'] ==80) & (DATAFRAME['COLUMN2'] =='86%')])

and its showing an error.

"[col1,col2,col3,col4....coln] not found in axis"

selection is working

DATAFRAME.loc[(DATAFRAME['COLUMN1'] ==80) & (DATAFRAME['COLUMN2'] =='86%')]

Are you deleting colums in a table or rows? – Scott Boston Mar 24 '22 at 12:36 — Scott Boston, Mar 24 '22 at 12:36
Hi, please consider providing a [mcve]. – rpanai Mar 25 '22 at 12:26 — rpanai, Mar 25 '22 at 12:26

David · Answer 1 · 2022-03-24T12:35:04.890

0

you can use:

DATAFRAME = DATAFRAME.loc[~((DATAFRAME['COLUMN1'] ==80) & (DATAFRAME['COLUMN2'] =='86%'))]

edited Mar 24 '22 at 12:35

answered Mar 24 '22 at 12:15

David

871
1
5
13

This is selection and showing wrong invalid syntax – deepankar srigyan Mar 24 '22 at 12:31
It was a typo. just fixed it – David Mar 24 '22 at 12:35
i was planning to get rid from all the data where coulmn1==80 and column2=86%, seems like it removed everything where column1==80, whats wrong – deepankar srigyan Mar 24 '22 at 13:04

score 0 · Answer 2 · answered Mar 25 '22 at 12:20

Since selection works as intended you can get the index of the rows meeting your criteria and use this approach. For your case it would look like this:

DATAFRAME.drop(DATAFRAME.loc[(DATAFRAME['COLUMN1'] == 80) & (DATAFRAME['COLUMN2'] == "86%")].index)

score 0 · Answer 3 · answered Mar 25 '22 at 12:33

Why don't you use just filtering here?

import pandas as pd
DATAFRAME = pd.DataFrame(
    {"COLUMN1":[80, 100, 80],
    "COLUMN2": ['84%','85%', '86%' ]})

These are the indicies where your conditions are satisfied

cond = (DATAFRAME['COLUMN1'].eq(80) &  
     DATAFRAME['COLUMN2'].eq('86%'))

0    False
1    False
2     True
dtype: bool

So in order to drop them you can just filter

DATAFRAME[~cond]

which gives you the following output

   COLUMN1 COLUMN2
0       80     84%
1      100     85%

delete column based on two conditions in a dataframe

3 Answers3