Subset pandas dataframe using values from two columns

Question

I am trying to subset a pandas dataframe based on values of two columns. I tried this code: df[df['gold']>0, df['silver']>0, df['bronze']>0] but this didn't work.

I also tried: df[(df['gold']>0 and df['silver']>0). This didn't work too. I got an error saying:

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

What would you suggest?

Duplicate stackoverflow.com/questions/21415661/…

Eulenfuchswiesel
– Eulenfuchswiesel

2018-05-15 12:24:31 +00:00
Commented May 15, 2018 at 12:24 — Eulenfuchswiesel
– Eulenfuchswiesel, Commented May 15, 2018 at 12:24

Pranay Aryal · Accepted Answer · 2017-02-25 20:13:56Z

16

I will answer my own question, hoping it will help someone. I tried this and it worked. df[(df['gold']>0) & (df['silver']>0)]

Note that I have used & instead of and and I have used brackets to separate the different conditions.

answered Feb 25, 2017 at 20:13

Pranay Aryal

5,4166 gold badges33 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Subset pandas dataframe using values from two columns

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related