How to write multiple conditional statements for loc dataframe with operators

Question

I'm trying to create a loc dataframe with multiple conditional statements. The problem I am having is that when I use and 'and' operator for my second conditional statement, I get the error below.

As a side problem, is there any better way to seperate the conditional statements than with |.

My code:

df = df2.loc[(df2['Position'] == 0) | (df2['TABNo'] == 0 and df2['IsBarrierTrial'] == 'FALSE')]

Error with and operator:

The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().

What is the problem with the operator |?

T C Molenaar
– T C Molenaar

2022-08-18 14:05:04 +00:00
Commented Aug 18, 2022 at 14:05 — T C Molenaar
– T C Molenaar, Commented Aug 18, 2022 at 14:05
Nothing just not neat

onthepunt
– onthepunt

2022-08-18 14:14:01 +00:00
Commented Aug 18, 2022 at 14:14 — onthepunt
– onthepunt, Commented Aug 18, 2022 at 14:14

Celius Stingher · Accepted Answer · 2022-08-18 13:58:28Z

1

Make sure they are correctly separated by parenthesis to group the logics and consider using bitwise operator:

df = df2.loc[(df2['Position'] == 0) | ((df2['TABNo'] == 0) & (df2['IsBarrierTrial'] == 'FALSE'))]

answered Aug 18, 2022 at 13:58

Celius Stingher

18.4k6 gold badges26 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

How to write multiple conditional statements for loc dataframe with operators

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related