How to find out if value in column is in list of values in Pandas?

Asked Mar 01 '19 at 16:26

Active Mar 01 '19 at 16:26

Viewed 19 times

I want to get rows of dataFrame if value in some column is in the list of acceptable values. So I'm trying to get series of bool values first to use them for dataframe indexing.

I'm getting ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all(). Why is that and how can I solve my task?

c = ['m','n','a']
df = pd.DataFrame({'c':c})
df['c'] == 'm'                    #works
df['c'] in ['m','x']              #valueError!
df['c'] == 'm' or df['c'] == 'x'  #same error! Why?

asked Mar 01 '19 at 16:26

Dork

1,816
9
29
57

1

`df['c'].isin(['m','x'])` and `(df['c'] == 'm' )|( df['c'] == 'x')` – BENY Mar 01 '19 at 16:28
@Wen-Ben quick work, but would be better as an answer, no? – G. Anderson Mar 01 '19 at 16:29
1

@G.Anderson very common question :-) – BENY Mar 01 '19 at 16:30
Right, that lol. nvm! :) – G. Anderson Mar 01 '19 at 16:38

How to find out if value in column is in list of values in Pandas?

0 Answers0