Count Unique Values from Index in Pandas

To return a Series containing counts of unique values from Index object sorted in Ascending Order, use the index.value_counts() method with parameter ascending as True.

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 sorted in ascending order −

print("\nGet the count of unique values sorted in ascending order..." "\n",index.value_counts(ascending=True))

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 sorted in ascending order
print("\nGet the count of unique values sorted in ascending order..." "\n",index.value_counts(ascending=True))

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 sorted in ascending order...
10   1
70   1
30   1
50   2
110  2
90   2
dtype: int64