.index

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