Python Pandas - Get integer location for requested label and find the nearest index value if no exact match

PythonPandasServer Side ProgrammingProgramming

To get integer location for requested label and find the nearest index value if no exact match, use the index.get_loc(). Set the method parameter value to nearest.

At first, import the required libraries −

import pandas as pd

Creating Pandas index −

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

Display the Pandas index −

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

Get the location of the nearest index value if no exact match. The value is set "nearest" using the "method" parameter of the get_loc().

print("\nGet the location of the nearest index if no exact match...\n", index.get_loc(58, method="nearest"))

Example

Following is the code −

import pandas as pd

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

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

# get integer location from the given index
print("\nDisplay integer location from given index...\n",index.get_loc(20))
print("\nDisplay integer location from given index...\n",index.get_loc(50))

# Get the location of the nearest index value if no exact match
# The value is set "nearest" using the "method" parameter of the get_loc()
print("\nGet the location of the nearest index if no exact match...\n", index.get_loc(58, method="nearest"))

Output

This will produce the following output −

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

Number of elements in the index...
7

Display integer location from given index...
1

Display integer location from given index...
4

Get the location of the nearest index if no exact match...
5
raja
Updated on 14-Oct-2021 08:48:59

Advertisements