# Python - Find indices where elements should be inserted to maintain order in Pandas Index

PythonServer Side ProgrammingProgramming

#### Beyond Basic Programming - Intermediate Python

Most Popular

36 Lectures 3 hours

#### Practical Machine Learning using Python

Best Seller

91 Lectures 23.5 hours

#### Practical Data Science using Python

22 Lectures 6 hours

To Find indices where elements should be inserted to maintain order in Pandas Index, use the index.searchsorted() method.

At first, import the required libraries −

import pandas as pd

Creating Pandas index −

index = pd.Index([10, 20, 30, 40, 50])


Display the Pandas index −

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

Searchsorted: set the value to insert and get the exact index position where it should be placed −

print("\nThe exact positions where the element should be placed?...\n",index.searchsorted(45))

## Example

Following is the code −

import pandas as pd

# Creating Pandas index
index = pd.Index([10, 20, 30, 40, 50])

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

# searchsorted
# set the value to insert and get the exact index position where it should be placed
print("\nThe exact positions where the element should be placed?...\n",index.searchsorted(45))

## Output

This will produce the following output −

Pandas Index...
Int64Index([10, 20, 30, 40, 50], dtype='int64')

Number of elements in the index...
5

The exact positions where the element should be placed?...
4
Updated on 14-Oct-2021 06:32:44