Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Python Pandas - Get integer location for requested label and find the nearest index value if no exact match
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
Updated on: 14-Oct-2021
149 Views
Advertisements