How to reset the index of a Pandas DataFrame
• 1 minOften when merging multiple DataFrames you might end up with a messed up index.
One solution to this is to apply the DataFrame.reset_index() method.
Pandas will completely reset your index to a new sequential index while keeping the old index as a new column.
import pandas as pd
# We creeate our sample dataframe
df = pd.DataFrame(index=[2,0,1,4,2],
data={"col1" : range(0,5)})
# We reset the index
df = df.reset_index()
# or if you don't want to keep the old index
df = df.reset_index(drop=True)
Here you are! You now know how to reset the index of a Pandas DataFrame.
More on DataFrames
If you want to know more about DataFrame and Pandas. Check out the other articles I wrote on the topic, just here :
Pandas - The Python You Need
We gathered the only Python essentials that you will probably ever need.