dataframe.isin using multiple OR operators

Question

I want to see if I have some values from a list in multiple columns from my pandas dataframe.

Basically, I want to look over my column A, B and C if the values from a list exists and if so filter the rows where those values exist. For that I am using this:

processes = ['process_A', 'process_B']
df[df.col_A.isin(processes),df.col_B.isin(processes), df.col_C.isin(processes)].any()

And already try this:

df[df.col_A.isin(processes) OR df.col_B.isin(processes) or df.col_C.isin(processes)]

But I got a lot of errors or unexpectables results.

Adam.Er8 · Accepted Answer · 2019-07-03 13:44:06Z

2

.isin returns a boolean Series, you need to use | for logical OR between the values.

try this:

df[df.col_A.isin(processes) | df.col_B.isin(processes) | df.col_C.isin(processes)]

answered Jul 3, 2019 at 13:44

Adam.Er8

13.5k3 gold badges32 silver badges43 bronze badges

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

Comments

BENY · Accepted Answer · 2019-07-03 14:12:12Z

0

Using any as below

df[df[['col_A','col_B','col_C']].isin(processes).any(1)]

answered Jul 3, 2019 at 14:12

BENY

324k22 gold badges176 silver badges250 bronze badges

Collectives™ on Stack Overflow

dataframe.isin using multiple OR operators

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related