.index

Published May 12, 2024
Contribute to Docs

The .index attribute represents the row labels (index) of the DataFrame. It returns an Index object and can be used to view or assign new values to the row labels.

Syntax

pandas.DataFrame.index

Example

In the following example, the .index attribute is used to view and modify the row labels of the monthlyCost DataFrame:

import pandas as pd
# Creating the DataFrame representing monthly cost of 4 items
data = {'April': [88, 92, 79, 85],
'May': [94, 77, 90, 78],
'June': [89, 80, 95, 81]}
monthlyCost = pd.DataFrame(data)
# Print the DataFrame
print(f'{monthlyCost} \n')
# modify the row labels
monthlyCost.index = ['bread', 'milk', 'apples', 'onions']
# print the modified monthlyCost Dataframe
print(f'{monthlyCost} \n')
# print the row label or index of monthlyCost DataFrame
print(monthlyCost.index)

The output for the above code is as follows:

April May June
0 88 94 89
1 92 77 80
2 79 90 95
3 85 78 81
April May June
bread 88 94 89
milk 92 77 80
apples 79 90 95
onions 85 78 81
Index(['bread', 'milk', 'apples', 'onions'], dtype='object')

Codebyte Example

The following Codebyte Example demonstrates how to view and update a DataFrame using the .index attribute:

us
Visit us
code
Hide code
Code
Output
Hide output
Hide output
Loading...

All contributors

Looking to contribute?

Learn Python:Pandas on Codecademy