How to Convert Index to Column in Pandas Dataframe?

belongs to collection: Python Pandas Programs

mahmoud2506

Save to bookmark

2022-05-25

161

Pandas is a special tool that allows us to perform complex manipulations of data effectively and efficiently. In a DataFrame, each row is assigned with an index value ranging from 0 to n-1. The 0th is the first row and n-1th index is the last row. Pandas provides us the simplest way to convert the index into a column.

We will create a new column and assign the index value of each row with the help of using DataFrame.index() method.

pandas.DataFrame.index() Method

In Pandas DataFrame, both rows and columns have indexes, where each index value means that particular number of rows in a DataFrame. This method returns a list of all the index values which are assigned with each row.

Syntax:

DataFrame.index()

To work with Python Pandas, we need to import the pandas library. Below is the syntax,

import pandas as pd

Python programming, examples, Python programming examples,

All Answers

mahmoud2506

2022-05-25

need an explanation for this answer? contact us directly to get an explanation for this answer

Example:

# Importing pandas package
import pandas as pd

# Creating a dictionary of student marks
d = {
    "Peter":[65,70,70,75],
    "Harry":[45,56,66,66],
    "Tom":[67,87,65,53],
    "John":[56,78,65,64]
}

# Now, create DataFrame and assign index name 
# as subject names
df = pd.DataFrame(d,index=["Maths","Physics","Chemistry","English"])

# Printing the DataFrame
print("\noriginal DataFrame\n\n",df,"\n\n")

# Create a new column and insert its values 
# using DataFrame.index() method
df['index'] = df.index

# Printing new DataFrame
print("\nNew DataFrame\n\n",df)

Output:

original DataFrame

            Peter  Harry  Tom  John
Maths         65     45   67    56
Physics       70     56   87    78
Chemistry     70     66   65    65
English       75     66   53    64 



New DataFrame

            Peter  Harry  Tom  John      index
Maths         65     45   67    56      Maths
Physics       70     56   87    78    Physics
Chemistry     70     66   65    65  Chemistry
English       75     66   53    64    English

Convert Index to Column | Output