Why is filtering with multiple conditions not working?

Question

I need to filter my DataFrame based on two conditions. I need to filter out any observation where cause = 'fire' AND the flag = 1. It can be fire and flag = 0. It can be flag = 1 and cause != 'fire'. Just not both at the same time.

I tried the following:

 df.loc[(df['flag'] != 1) & (df['cause'] != 'Fire')]

But this gets rid of all 1s and/or fire. I need both conditions to be met to be filtered out. Not sure where I'm going wrong.

Rob Raymond · Accepted Answer · 2020-12-29 21:34:59Z

1

built a DF with contents you defined. Make sure you code your logic. You state NOT(cause=="Fire" AND flag==1)

import random
c = ["Fire","Water"]
df = pd.DataFrame({"flag":[random.randint(0,1) for r in range(10)], "cause":[c[random.randint(0,1)] for r in range(10)]})

df.loc[~((df['flag'] == 1) & (df['cause'] == 'Fire'))]

edited Dec 29, 2020 at 21:34

answered Dec 29, 2020 at 20:32

Rob Raymond

31.5k3 gold badges19 silver badges34 bronze badges

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

2 Comments

Jordan Over a year ago

But that filters out Fire with '0' for the flag.

Rob Raymond Over a year ago

updated - just code the logic you state and it works

Collectives™ on Stack Overflow

Why is filtering with multiple conditions not working?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related