Python Pandas - Return a Series containing counts of unique values from Index object


To return a Series containing counts of unique values from Index object, use the index.value_counts() method in Pandas.

At first, import the required libraries -

import pandas as pd

Creating Pandas index −

index = pd.Index([50, 10, 70, 110, 90, 50, 110, 90, 30])

Display the Pandas index −

print("Pandas Index...\n",index)

Count of unique values −

print("\nGet the count of unique values...\n",index.value_counts())

Example

Following is the code −

import pandas as pd

# Creating Pandas index
index = pd.Index([50, 10, 70, 110, 90, 50, 110, 90, 30])

# Display the Pandas index
print("Pandas Index...\n",index)

# Return the number of elements in the Index
print("\nNumber of elements in the index...\n",index.size)

# Return the dtype of the data
print("\nThe dtype object...\n",index.dtype)

# count of unique values
print("\nGet the count of unique values...\n",index.value_counts())

Output

This will produce the following output −

Pandas Index...
Int64Index([50, 10, 70, 110, 90, 50, 110, 90, 30], dtype='int64')

Number of elements in the index...
9

The dtype object...
int64

Get the count of unique values...
50   2
110  2
90   2
10   1
70   1
30   1
dtype: int64

Updated on: 13-Oct-2021

231 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements