Pandas reset_index() - change default to drop index

Question

I've been using Python and Pandas for years and know it well, but I use the reset_index() feature a lot and I'd say 95% of the time, also use drop = True as a keyword. If I'm resetting the index, I think it's a good bet that I don't want to keep the old index in my dataframe. Is there a way to set drop = True as the default, and if I don't want to drop it, instead use drop = False?

I looked at the pd.set_option() documentation and didn't see what I was looking for.

Changing the source code? pandas/core/frame.py and pandas/core/series.py; finding the reset_index method in there and changing default value of keyword argument drop. — Mustafa Aydın
– Mustafa Aydın, Commented May 24, 2021 at 17:36
That might be the only way. I know there are some options you can change that don't require changing the source code, thus the question. But thanks for the paths, I'll check it out. — elPastor
– elPastor, Commented May 24, 2021 at 17:45

Nk03 · Accepted Answer · 2021-05-24 17:29:44Z

3

You can add a new reset_index method:

pd.DataFrame.my_reset_index = lambda self: self.reset_index(drop=True)
df = df.my_reset_index()

answered May 24, 2021 at 17:29

Nk03

15k2 gold badges11 silver badges24 bronze badges

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

1 Comment

elPastor Over a year ago

Interesting, and that could be done directly within the module? No need to mess with the source code? I don't love that I'd have to update literally hundreds of reset_index() in my code, but that's definitely an option.

Collectives™ on Stack Overflow

Pandas reset_index() - change default to drop index

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