Select Column with multiple condition pandas

Question

Get column value with condition from another column. For example I have dataframe

Package   Drink  Age   Name
Full       Tea   50    Toni
Half       Tea   50    Stark
Full       Tea   20    Evan
Half       Tea   50    Christ
Quarter    Tea   61    Mark
Quarter    Tea   18    Rufallo

Then I want to get name only '''if package==full or Half and Age =>50'''

The output I expected is

Tony
Stark
Christ

I saw some guidance in internet, then I wrote subdf= df[(df["Package"] == 'Full') | (data["Package"] == 'Half' & (data['Age'] >= 50)), 'Name']

but it is not working. the error say, 'Invalid index error'

jezrael · Accepted Answer · 2022-11-10 10:36:50Z

1

Use DataFrame.loc for select only column name with mask, for check membership use Series.isin:

subdf= df.loc[df["Package"].isin([ 'Full','Half']) & (df['Age'] >= 50), 'Name']
print (subdf)
0      Toni
1     Stark
3    Christ
Name: Name, dtype: object

Your solution with multiple | for bitwise OR:

subdf= df.loc[((df["Package"] == 'Full') | (df["Package"] == 'Half')) & 
               (df['Age'] >= 50), 'Name']

answered Nov 10, 2022 at 10:36

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Select Column with multiple condition pandas

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