Pandas - Get index values of a DataFrame as a List

python Share on :

In this post, we are going to explain to get the index values of a DataFrame. We will get the index values in a List. We will be using DataFrame.index.values to do it.

import pandas as pd

# create a dataframe
df = pd.DataFrame({
  "id": [1, 2, 3, 4, 5],
  "name": ["Joy", "Rick", "Carol", "Dumpty", "Clark"],
  "designation": ["Programmer", "Manager", "Admin", "Accountant", "Designer"]
})

print(df)

# get all the indexes
indexes = df.index.values.tolist()

print("All indexes of DataFrame df are: ", end="")
print(indexes)

Output

╒════╤══════╤════════╤═══════════════╕
│    │   id │ name   │ designation   │
╞════╪══════╪════════╪═══════════════╡
│  0 │    1 │ Joy    │ Programmer    │
├────┼──────┼────────┼───────────────┤
│  1 │    2 │ Rick   │ Manager       │
├────┼──────┼────────┼───────────────┤
│  2 │    3 │ Carol  │ Admin         │
├────┼──────┼────────┼───────────────┤
│  3 │    4 │ Dumpty │ Accountant    │
├────┼──────┼────────┼───────────────┤
│  4 │    5 │ Clark  │ Designer      │
╘════╧══════╧════════╧═══════════════╛


All indexes of DataFrame df are: [0, 1, 2, 3, 4]

If you want to get all the index values of a DataFrame, you can use one of the code examples explained below.

# Method 1: Using df.index.values.tolist()

We can get df.index object from the DataFrame and then get the index values from it. In order to do that we can use the below code.

result = df.index.values.tolist()

# Method 2: Using list(df.index.values)

result = list(df.index.values)

Example 2

import pandas as pd

# create a dataframe
df = pd.DataFrame({
  "col_a": ["A", "B", "C", "D", "E"],
  "col_b": [10, 20, 30, 40, 50]
})

# get all the indexes
indexes = list(df.index.values)

print(indexes)

Output

[0, 1, 2, 3, 4]

Contribute to this Snippet

Was this helpful?

Created by :

@

Write your Comment

0 Comments

Similar code snippets

Create your own code snippets and search them using our portal and chrome extension

Programming Feeds

Learn something new everyday on Devsheet

Important Links

Join Devsheet Create new snippet Ask a Question Write an article Online JSON Viewer