Pandas + Delete specific rows not by index [duplicate]

Question

I've started learning pandas and have found an issue which I can't seem to resolve. I am loading a data from a csv file and need to delete some rows matching a few strings.

CSV:

id fullname city  tst
999      bbb  CIT  aaa
888      bbb  CIT  aaa
777      xxx  JJJ  aaa

What I've tried:

import pandas as pd

df = pd.read_csv('zzz.csv')

#to_drop = ['xxx', 'aaa']

df = df.drop('xxx',axis=0)

but I am getting the error below:

KeyError: "['xxx'] not found in axis"

What I am missing here? Also, what if I want to pass a list and delete all rows matching strings from the list? Example:

to_drop = ['xxx', 'aaa']

df = df.drop(to_drop,axis=0)

As mentioned in the comment above, you can use a boolean expression to choose rows. As for what's wrong with your attempt, is that you did not set an index, which is required by drop. Try: df.set_index("fullname").drop("xxx", axis=0) — suvayu
– suvayu, Commented Jul 26, 2021 at 19:24

EMiller · Accepted Answer · 2021-07-26 19:22:21Z

1

I suggest:

df = df[df.fullname!='xxx']

and for a list:

names=['xxx','bbb']
df = df[~df.fullname.isin(names)]

the ~ operator means "not"

answered Jul 26, 2021 at 19:22

EMiller

8391 gold badge7 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Pandas + Delete specific rows not by index [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related