Coding Ref

How to reset index in a Pandas DataFrame

How to reset index in a Pandas DataFrame

To reset the index in a Pandas DataFrame, you can use the .reset_index() method.

This method will convert the current index values in the DataFrame to row numbers, starting from 0.

Example

Here is an example:

main.py
import pandas as pd

# Create a sample Pandas DataFrame
df = pd.DataFrame({'fruit': ['apple', 'orange', 'apple', 'banana'],
                   'color': ['red', 'orange', 'green', 'yellow']})

# Use the reset_index() method to reset the index
df = df.reset_index()

# Print the DataFrame
print(df)

This will output the following DataFrame, with a new, default index that starts from 0:

output
   index   fruit   color
0      0   apple     red
1      1  orange  orange
2      2   apple   green
3      3  banana  yellow

In this example, df is the name of the DataFrame that you are working with.

You can replace it with the name of your DataFrame if it is different.

You'll also like

Related tutorials curated for you

    How to sort by two columns in Pandas

    How to use str.split() in Pandas

    How to GroupBy Index in Pandas

    What is idxmax() in Pandas?

    How to convert a series to a NumPy array in Pandas

    How to convert a Pandas Index to a List

    How to drop duplicate rows in Pandas

    How to get the number of columns in a Pandas DataFrame

    fillna() in Pandas

    How to drop duplicate columns in Pandas

    How to normalize a column in Pandas

    What does Count() do in Pandas?