Using "not in list" syntax in pandas select

Question

I am trying to do something like

exclude_values = range(low, high)  # for the sake of example
df = df[df['blah'] not in exclude_values]

which just raises the "truth value of a Series is ambiguous" exception. The problem is, I can't see how to change this syntax so as not to use not in. What (presumably very obvious) thing am I missing?

score 1 · Accepted Answer · edited Sep 23 '19 at 13:25

1

Use isin

df[~df['blah'].isin(exclude_values)]

edited Sep 23 '19 at 13:25

rafaelc

57,686
15
58
82

answered Sep 23 '19 at 13:02

Danny

470
4
14

score 0 · Answer 2 · edited Sep 23 '19 at 13:25

0

Use idiomatic pandas methods and bitwise logic:

df = df[~round(df.blah).isin(exclude_values)]

edited Sep 23 '19 at 13:25

rafaelc

57,686
15
58
82

answered Sep 23 '19 at 13:04

Gavin Kirby

43
10

Using "not in list" syntax in pandas select

2 Answers2