The index in a Pandas dataframe can be reset to the original ordering of the columns. This is done with the reset_index() method, and it will return a new DataFrame that has all of its indexes set to their original values.In this article, Pandas Reset index will be discussed with examples for proper learning.
Table of Contents
How to Reset the Index of a DataFrame?
Well, pandas has a function called reset_index() that can help us solve this problem quickly!
Let’s see how to use it in different ways:
Example 01: Original DataFrame
import pandas as pd
data = {'FirstName': ['Anmol', 'Sakshi', 'Maryam'],
'LastName': ['Lohana', 'Chawla', 'Pathan'],
'Age': [23, 25, 27]}
df = pd.DataFrame(data)
print(df) Output
Example 02: Making own index without replacing the existing one
import pandas as pd
data = {'FirstName': ['Anmol', 'Sakshi', 'Maryam'],
'LastName': ['Lohana', 'Chawla', 'Pathan'],
'Age': [23, 25, 27]}
index = {'One', 'Two', 'Three'}
df = pd.DataFrame(data, index)
df.reset_index(inplace = True)
print(df) Output
Example 03: Make the default index the index and reset the own index.
import pandas as pd
data = {'FirstName': ['Anmol', 'Sakshi', 'Maryam'],
'LastName': ['Lohana', 'Chawla', 'Pathan'],
'Age': [23, 25, 27]}
index = {'One', 'Two', 'Three'}
df = pd.DataFrame(data, index)
df.reset_index(inplace = True, drop = True)
print(df) Output
Example 04: Remove the default index from a dataframe column and use it as an index.
import pandas as pd
data = {'FirstName': ['Anmol', 'Sakshi', 'Maryam'],
'LastName': ['Lohana', 'Chawla', 'Pathan'],
'Age': [23, 25, 27]}
index = {'One', 'Two', 'Three'}
df = pd.DataFrame(data, index)
df.set_index(['Age'], inplace = True)
print(df) Output
Example 05: Make a dataframe column an index without removing the default index. import pandas as pd
import pandas as pd
data = {'FirstName': ['Anmol', 'Sakshi', 'Maryam'],
'LastName': ['Lohana', 'Chawla', 'Pathan'],
'Age': [23, 25, 27]}
index = {'One', 'Two', 'Three'}
df = pd.DataFrame(data, index)
df.set_index(['Age'], inplace = True)
df.reset_index(level =['Age'], inplace = True)
print(df) Output
Conclusion
The order of columns can be changed by using the reset_index() method, which will return a new DataFrame with all indexes set to their original values. You’ll want to make sure that your syntax is correct before running this command as it could lead to unintended consequences if not executed properly.
