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

3 回答

• 22

  reset_index()是你希望它保存为列的内容，然后执行：

  df = df.reset_index(drop=True)
  

  回复于 2024-04-30T02:24:34+08:00
• 0

  data1.reset_index(inplace=False)
  

  回复于 2024-04-30T02:24:34+08:00
• 437

  另一个解决方案是分配 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 loop
  
  In [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 loop
  
  In [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
  

  回复于 2024-04-30T02:24:34+08:00