Remove rows from dataframe based on index

Question

I got a list containing row indexes to delete. The list contains duplicates so to lighten the burden I tried to remove duplicate entries:

invalid_rows = list(dict.fromkeys(invalid_rows))

Returning: TypeError: unhashable type: 'list'

Okey, well let's try with duplicate values just to see if I can remove the rows:

df = df.drop(index=invalid_rows)

Returning the same error code. What's the problem with the list? I tried to google but I can't seem to find the error.

Hard to tell without knowing what invalid_rows looks like. You should provide a stackoverflow.com/help/minimal-reproducible-example Did you consider using pandas.pydata.org/pandas-docs/stable/reference/api/… ? — Feodoran
– Feodoran, Commented Dec 18, 2021 at 17:36

Tugay · Accepted Answer · 2021-12-18 17:39:16Z

1

I am guessing that invalid_rows is not a list, it is actually a nested list. fromkeys method tries to use elements of that list as keys for dictionary, but since its elements (at least one of them) are not hashable type, it raises an error.

answered Dec 18, 2021 at 17:39

Tugay

2,2115 gold badges23 silver badges37 bronze badges

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

Comments

itprorh66 · Accepted Answer · 2021-12-18 17:39:54Z

1

A simple way to remove duplicates from a list would be:

invalid_rows = list(set(invalid_rows))

This of course assumes invalid_rows is a list of hashable items

answered Dec 18, 2021 at 17:39

itprorh66

3,2784 gold badges13 silver badges26 bronze badges

2 Comments

enzo Over a year ago

The error already says that invalid_rows contains an unhashable type.

OldSport Over a year ago

Thanks, it seem like my list is nested for some reason. Will try to figure it out.

Collectives™ on Stack Overflow

Remove rows from dataframe based on index

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related