python pandas loc - filter for list of values

python pandas filter loc
jeangelj picture jeangelj · Aug 21, 2017 · Viewed 79.2k times · Source

This should be incredibly easy, but I can't get it to work.

I want to filter my dataset on two or more values. 

#this works, when I filter for one value
df.loc[df['channel'] == 'sale'] 

#if I have to filter, two separate columns, I can do this
df.loc[(df['channel'] == 'sale')&(df['type']=='A')] 

#but what if I want to filter one column by more than one value?
df.loc[df['channel'] == ('sale','fullprice')]

Would this have to be an OR statement? I can do something like in SQL using in?

Answer

taras picture taras · Aug 21, 2017

There is a df.isin(values) method wich tests whether each element in the DataFrame is contained in values. So, as @MaxU wrote in the comment, you can use 

df.loc[df['channel'].isin(['sale','fullprice'])]

to filter one column by multiple values.

Related questions

how do you filter pandas dataframes by multiple columns

To filter a dataframe (df) by a single column, if we consider data with male and females we might: males = df[df[Gender]=='Male'] Question 1 - But what if the data spanned multiple years and i wanted to only see …

Read More
Filtering Pandas Dataframe using OR statement

I have a pandas dataframe and I want to filter the whole df based on the value of two columns in the data frame. I want to get back all rows and columns where IBRD or IMF != 0. alldata_balance = alldata[(…

Read More
Python: Pandas filter string data based on its string length

I like to filter out data whose string length is not equal to 10. If I try to filter out any row whose column A's or B's string length is not equal to 10, I tried this. df=pd.read_csv('filex.…

Read More