need to drop the rows in data frame based on the values which has in a separate list

Question

For Example im having a data frame

col1   col2   col3

a      12      34

b      23      67

c      67      86

im having list

list=['b','f','r']

i need to remove the rows in the data frame which was there in the list

Can you tell us what have you tried and what are the indexes of your rows? Do you get any errors? — harvpan, Jun 19 '18 at 17:28

koPytok · Accepted Answer · 2018-06-19T17:41:06.867

1

You need series.isin:

df[~df["col1"].isin(lst)]

P.S. Please, avoid calling variables with python reserved words like list.

edited Jun 19 '18 at 17:41

answered Jun 19 '18 at 17:29

koPytok

3,453
1
14
29

score 0 · Answer 2 · answered Jun 19 '18 at 17:29

Setup:

l = ['b','f','r']

df = pd.DataFrame(
         {'col1': {0: 'a', 1: 'b', 2: 'c'},
          'col2': {0: 12, 1: 23, 2: 67},
          'col3': {0: 34, 1: 67, 2: 86}
            })

Now use the .isin method and negate it with a ~

df[~df.col1.isin(l)]

Out:

  col1  col2  col3
0    a    12    34
2    c    67    86

need to drop the rows in data frame based on the values which has in a separate list

2 Answers2