Python Pandas - Return the integer indices that would sort the index


To return the integer indices that would sort the index, use the index.argsort() method in Pandas. At first, import the required libraries −

import pandas as pd

Creating Pandas index −

index = pd.Index(['Electronics','Accessories','Decor', 'Books', 'Toys'], name ='Products')

Display the Pandas index −

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

Return the integer indices that would sort the index −

res = index.argsort()

Example

Following is the code −

import pandas as pd

# Creating Pandas index
index = pd.Index(['Electronics','Accessories','Decor', 'Books', 'Toys'], name ='Products')

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

res = index.argsort()

# Return the integer indices that would sort the index
print("\nThe integer indices to sort the index...\n",res)

print("\nOrdered..\n",index[res])

Output

This will produce the following output −

Pandas Index...
Index(['Electronics', 'Accessories', 'Decor', 'Books', 'Toys'], dtype='object', name='Products')

Number of elements in the index...
5

The dtype object...
object

The integer indices to sort the index...
[1 3 2 0 4]

Ordered..
Index(['Accessories', 'Books', 'Decor', 'Electronics', 'Toys'], dtype='object', name='Products')

Updated on: 14-Oct-2021

102 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements