Filtering DataFrame on multiple conditions in Pandas

Question

For my class I need to find the sepal length in the iris dataset that is between 4.5 and 6. exact specifications are "Select the rows that that has sepal length greater than 4.5 but less than 6" the given code (which the answer should be in this form) is

    subset=data[data['petal width (cm)']>2]

what I have is:

    subset=data[data[(['sepal length (cm)']>4.5 and ['sepal length (cm)']<6)]]

the main problem I am having is getting the syntax correct. in its current state, I get an error stating

    TypeError: '>' not supported between instances of 'list' and 'float'

If it is changed to

    subset=data[data[(data['petal width (cm)']>4.5 and data['petal width (cm)']<6)]]

I get the error

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

thank you

subset=data[(data[(['sepal length (cm)']>4.5) & (['sepal length (cm)']<6)])]. You need to wrap each condition in parentheses and create "and" logic with &. I suggest you read the documentation on boolean indexing. — cmaher
– cmaher, Commented Jan 17, 2018 at 1:53
Possible duplicate of Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all() — cmaher
– cmaher, Commented Jan 17, 2018 at 1:59
I understand why the parentheses, I will look into as to why a & is required but when I try your solution I get TypeError: '>' not supported between instances of 'list' and 'float' — Adam
– Adam, Commented Jan 17, 2018 at 2:00
My fault, there was a typo in there -- you need this subset = data[(data['sepal length (cm)'] > 4.5) & (data['sepal length (cm)'] < 6)] — cmaher
– cmaher, Commented Jan 17, 2018 at 2:03
That worked. thank you. I realize that I did not wrap each one in parentheses and tried to add it all together. — Adam
– Adam, Commented Jan 17, 2018 at 2:33

slfan · Accepted Answer · 2018-09-10 20:39:31Z

2

subset = data[(data['sepal length (cm)'] > 4.5) & (data['sepal length (cm)'] < 6)]

Courtesy of @cmaher

edited Sep 10, 2018 at 20:39

slfan

9,129115 gold badges69 silver badges81 bronze badges

answered Sep 10, 2018 at 20:16

Adam

1172 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Filtering DataFrame on multiple conditions in Pandas

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