PYTHON

reset_index pandas

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

reset index with pandas

import pandas as pd

# Reset index
df = df.reset_index()

# Display DataFrame
print(df)

reset index pandas

df.reset_index(drop=True)

The following code shows how to reset the index of the DataFrame and drop the old index completely:

#reset index
df.reset_index(drop=True, inplace=True)

#view updated DataFrame
print(df)

   points  assists  rebounds
0      25        5        11
1      12        7         8
2      15        7        10
3      14        9         6
4      19       12         6
5      23        9         5
6      25        9         9
7      29        4        12

df reset index

df.reset_index()

df = df.reset_index(level=0)

How to convert index of a pandas dataframe into a column
df = df.reset_index(level=0)
df['index1'] = df.index

reset_index(drop=true)

In [194]: df.reset_index(drop=True)
Out[194]: 
  _worker_id  foo
0          A    1
1          B    2
2          C    3

pandas reset index

df.reset_index(
  drop=True, # to avoid the old index being added as a column
  inplace=False) # (default) return df with the new index, i.e. do not create a new object

reset index in pandas

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

pandas reset index from 0

import pandas as pd
data = {'Name': ['Bob', 'Dilan', 'is ', 'alive', '!']}
index = {'a', 'b', 'c', 'd', 'e'}
df = pd.DataFrame(data, index)
df
    Name
b    Bob
a  Dilan
d    is 
c  alive
e      !

df.reset_index(inplace = True)
df
  index   Name
0     b    Bob
1     a  Dilan
2     d    is 
3     c  alive
4     e      !

pandas reset index start from 0

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

Example 1: Reset Index & Drop Old Index pandas

import pandas as pd

#define DataFrame
df = pd.DataFrame({'points': [25, 12, 15, 14, 19, 23, 25, 29],
                   'assists': [5, 7, 7, 9, 12, 9, 9, 4],
                   'rebounds': [11, 8, 10, 6, 6, 5, 9, 12]},
                   index=[0, 4, 3, 5, 2, 1, 7, 6])

#view DataFrame
print(df)

   points  assists  rebounds
0      25        5        11
4      12        7         8
3      15        7        10
5      14        9         6
2      19       12         6
1      23        9         5
7      25        9         9
6      29        4        12

Reset Index & Retain Old Index as Column in pandas

import pandas as pd

#define DataFrame
df = pd.DataFrame({'points': [25, 12, 15, 14, 19, 23, 25, 29],
                   'assists': [5, 7, 7, 9, 12, 9, 9, 4],
                   'rebounds': [11, 8, 10, 6, 6, 5, 9, 12]},
                   index=['A', 'C', 'D', 'B', 'E', 'G', 'F', 'H'])

#view DataFrame
print(df)

   points  assists  rebounds
A      25        5        11
C      12        7         8
D      15        7        10
B      14        9         6
E      19       12         6
G      23        9         5
F      25        9         9
H      29        4        12