DataFrame.reset_index() to remove index and restore the default one at all levels in Pandas

Reset the index of the DataFrame.

options

level : Remove all levels by default. Only remove of given level ( list , str, int )
drop: Bool, default False.
inplace : Bool, default False. Modify the original DataFrame or not
col_level: int or str, default 0. Which levels are inserted into.
col_fill : for multiple level how the levels are to be named.

options

import pandas as pd 
my_dict={'NAME':['Ravi','Raju','Alex','Ron','King','Jack'],
         'ID':[1,2,3,4,5,6],
         'MATH':[80,40,70,70,70,30],
         'ENGLISH':[80,70,40,50,60,30]}
df = pd.DataFrame(data=my_dict)
print(df) # before reset_index()
df2=df.reset_index() # another dataframe df2 is used
print(df2)

When we reset the index, the old index is added as a column, and a new sequential index is used.
Check the difference in two print() outputs. Output


   NAME  ID  MATH  ENGLISH
0  Ravi   1    80       80
1  Raju   2    40       70
2  Alex   3    70       40
3   Ron   4    70       50
4  King   5    70       60
5  Jack   6    30       30
   index  NAME  ID  MATH  ENGLISH
0      0  Ravi   1    80       80
1      1  Raju   2    40       70
2      2  Alex   3    70       40
3      3   Ron   4    70       50
4      4  King   5    70       60
5      5  Jack   6    30       30

drop

If drop=False ( default ) then index will be inserted into as a column.

df.reset_index(drop=False) # default

Output is here for drop=False


	index	NAME	ID	MATH	ENGLISH
0	0	Ravi	1	80	80
1	1	Raju	2	40	70
2	2	Alex	3	70	40
3	3	Ron	4	70	50
4	4	King	5	70	60
5	5	Jack	6	30	30

Check that one index column is added in above column. Now let us see the output with dropt=True

df.reset_index(drop=True)

Output ( index column is removed )


	NAME	ID	MATH	ENGLISH
0	Ravi	1	80	80
1	Raju	2	40	70
2	Alex	3	70	40
3	Ron	4	70	50
4	King	5	70	60
5	Jack	6	30	30

inplace

Modify the DataFrame or not. Default is False ( inplace=False ). In this case before and after using reset_index() the DataFrame remain same.

df.reset_index(inplace=False)

Output

   NAME  ID  MATH  ENGLISH
0  Ravi   1    80       80
1  Raju   2    40       70
2  Alex   3    70       40
3   Ron   4    70       50
4  King   5    70       60
5  Jack   6    30       30

If we set in_place=True then the original DataFrame is modified. Let us check the DataFrame before and after using reset_index() while keeping the in_place=True. You can see the original DataFrme is changed.

print(df)
df.reset_index(inplace=True) 
print(df)

Output

   NAME  ID  MATH  ENGLISH
0  Ravi   1    80       80
1  Raju   2    40       70
2  Alex   3    70       40
3   Ron   4    70       50
4  King   5    70       60
5  Jack   6    30       30
   index  NAME  ID  MATH  ENGLISH
0      0  Ravi   1    80       80
1      1  Raju   2    40       70
2      2  Alex   3    70       40
3      3   Ron   4    70       50
4      4  King   5    70       60
5      5  Jack   6    30       30

Add a column with sequential numbers

Once we reset the index, the old index is added as a column, (first line below ). In second line we rename() the column to 'New_ID'. In third line we replaced the New_ID column value by adding 100 to (new ) index value.

df = df.reset_index() 
df = df.rename(columns={"index":"New_ID"})
df['New_ID'] = df.index + 100  # starting from 100

You can also use reset_index with MultiIndex.
You can get more examples of using date column at Exercise3

Pandas date_range() to_datetime() period_range()

Numpy arrays Python & MySQL Python- Tutorials

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here