5

Now I have dataframe and list.

A B
1 a 
2 b
3 c
4 d
5 e

list=[a,b,c]

I would like to drop rows by df.B refering to list.

I would like to below df

A B
4 d
5 e

How can I get this result?

Heisenberg
  • 4,787
  • 9
  • 47
  • 76

1 Answers1

24

You can use isin with inverted mask by ~.

I think list is not good name in python, better is L, because list is code word and if assign variable you override it:

L= ['a','b','c']

print (df[~df.B.isin(L)])
   A  B
3  4  d
4  5  e
jezrael
  • 822,522
  • 95
  • 1,334
  • 1,252