Often 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.

The Python You Need