How to reset index in a pandas dataframe? [duplicate] How to reset index in a pandas dataframe? [duplicate] python python

How to reset index in a pandas dataframe? [duplicate]


DataFrame.reset_index is what you're looking for. If you don't want it saved as a column, then do:

df = df.reset_index(drop=True)

If you don't want to reassign:

df.reset_index(drop=True, inplace=True)


Another solutions are assign RangeIndex or range:

df.index = pd.RangeIndex(len(df.index))df.index = range(len(df.index))

It is faster:

df = pd.DataFrame({'a':[8,7], 'c':[2,4]}, index=[7,8])df = pd.concat([df]*10000)print (df.head())In [298]: %timeit df1 = df.reset_index(drop=True)The slowest run took 7.26 times longer than the fastest. This could mean that an intermediate result is being cached.10000 loops, best of 3: 105 µs per loopIn [299]: %timeit df.index = pd.RangeIndex(len(df.index))The slowest run took 15.05 times longer than the fastest. This could mean that an intermediate result is being cached.100000 loops, best of 3: 7.84 µs per loopIn [300]: %timeit df.index = range(len(df.index))The slowest run took 7.10 times longer than the fastest. This could mean that an intermediate result is being cached.100000 loops, best of 3: 14.2 µs per loop


matomo