Data frames pandas python

Question

I have a data frame that looks like this:

id  age sallary
1    16   500
2    21   1000
3    25   3000
4    30   6000
5    40   25000

and a list of ids that I would like to ignore [1,3,5]

how can I get a data frame that will contain all the remaining rows: 2,4.

Big thanks for every one.

EdChum · Accepted Answer · 2015-02-03 10:58:06Z

1

Call isin and negate the result using ~:

In [42]:

ignore_ids=[1,3,5]
df[~df.id.isin(ignore_ids)]
Out[42]:
   id  age  sallary
1   2   21     1000
3   4   30     6000

answered Feb 3, 2015 at 10:58

EdChum

397k204 gold badges837 silver badges583 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1