Pythonic Way to have multiple Or's when conditioning in a dataframe

Question

Basically instead of writing

data[data['pos'] == "QB" | data['pos'] == "DST" | ...]

where there are many cases I want to check

I was trying to do something similar to this What's the pythonic method of doing multiple ors?. However, this

data[data['pos'] in ("QB", "DST", ...)]

doesn't work.

I read the documentation here http://pandas.pydata.org/pandas-docs/stable/gotchas.html but I'm still having issues.

What do you want to achieve? Just to check whether `data['pos']` is equal to some data? — ForceBru, Oct 06 '15 at 18:00

score 2 · Accepted Answer · answered Oct 06 '15 at 18:02

2

What you are looking for is Series.isin . Example -

data[data['pos'].isin(("QB", "DST", ...))]

This would check if each value from pos is in the list of values - ("QB", "DST", ...) . Similar to what your multiple | would do.

answered Oct 06 '15 at 18:02

Anand S Kumar

1 Answers1