Pandas Delete Row of Data where Index is String

Question

I have a dataframe where a few indexes are string values. How can I delete the rows of data where the index is a string value or a non integer? Thanks for your help.

Wes McKinney · Accepted Answer · 2012-09-16 22:07:47Z

4

I would suggest using boolean indexing:

mask = frame.index.map(lambda x: not isinstance(x, str))
frame = frame[mask]

answered Sep 16, 2012 at 22:07

Wes McKinney

106k32 gold badges146 silver badges109 bronze badges

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

2 Comments

scriptdiddy Over a year ago

I believe that before I set the index for the dataframe, the data type of that series is a string. So that when I run the boolean indexing, all of the dataframe is cleared. I try to change the datatype of the series before setting the index but I get the following error: invalid literal for int() with base 10 . Any suggestions?

unutbu Over a year ago

@scriptdiddy: To avoid the error, replace int(x) with the expression int(text) if x.isdigit() else x.

Collectives™ on Stack Overflow

Pandas Delete Row of Data where Index is String

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related