Python:Pandas .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)

Copy to clipboard
Copy to clipboard

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')

Copy to clipboard
Copy to clipboard

Codebyte Example

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

Visit us
Visit us
Hide code
Code
Output
Hide output
Loading...
Copy to your clipboard
Copy Codebyte
Run