猿问

如何重置pandas数据框中的索引?

如何重置pandas数据框中的索引?

我有一个数据框,我从中删除了一些行。结果,我得到一个数据框,其中索引是这样的:[1,5,6,10,11]我想将其重置为[0,1,2,3,4]。我该怎么做?


以下似乎有效:


df = df.reset_index()

del df['index']

以下不起作用:


df = df.reindex()


吃鸡游戏
浏览 2514回答 3
3回答

慕标琳琳

reset_index()是你在找什么。如果您不希望将其另存为列,请执行以下操作:df = df.reset_index(drop=True)

慕田峪7331174

data1.reset_index(inplace=True)

侃侃无极

另一种解决方案是分配RangeIndex或range:df.index = pd.RangeIndex(len(df.index))df.index = range(len(df.index))它更快: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
随时随地看视频慕课网APP

相关分类

Python
我要回答