Remove rows from Pandas DataFrame based on index condition

Question

I have a dataframe like this:

                    0           1           2           3           4
19238V105         NaN         NaN         NaN         NaN         NaN   
91731X102         NaN         NaN         NaN   2450900.0    996600.0   
97X1              NaN         NaN         NaN         NaN         NaN

I would like to drop all of the rows where: len(index) != 9. So the result would be:

                    0           1           2           3           4
19238V105         NaN         NaN         NaN         NaN         NaN   
91731X102         NaN         NaN         NaN   2450900.0    996600.0

EDIT

I wrote this code:

for index, row in df.iterrows():
    if len(index) != 9:
        df = df.drop(index)

Is there a better way? Also, I'm not entirely sure why both the index, row are required and not just index. Thanks

piRSquared · Accepted Answer · 2016-07-23 03:34:56Z

2

Try this:

df[df.index.str.len() >= 9]

answered Jul 23, 2016 at 3:34

piRSquared

296k68 gold badges509 silver badges654 bronze badges

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

1 Comment

smgeneralist Over a year ago

I modified this to == 9, but yes, this is what I was looking for. Thank you

Collectives™ on Stack Overflow

Remove rows from Pandas DataFrame based on index condition

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related