Q:

How to Convert Index to Column in Pandas Dataframe?

mahmoud2506
Save to bookmark
|
2022-05-25
|
  266 
0

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,
login and add your own answer to this question

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

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

total answers (1)

This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now