

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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 - Compute indexer and find the previous index value if no exact match
To compute indexer and find the previous index value if no exact match, use the index.get_indexer() method. Also set the method parameter to ffill.
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)
Compute indexer and mask using the "get_indexer". Find the previous index value if no exact match using the "method" parameter. The value is set "ffill" −
print("\nGet the indexes...\n",index.get_indexer([30, 20, 75, 80, 50, 59], method="ffill"))
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) # Compute indexer and mask using the "get_indexer" # Find the previous index value if no exact match using the "method" parameter. # The value is set "ffill" print("\nGet the indexes...\n",index.get_indexer([30, 20, 75, 80, 50, 59], method="ffill"))
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 Get the indexes... [2 1 6 6 4 4]
- Related Questions & Answers
- Python Pandas - Compute indexer and find the next index value if no exact match
- Python Pandas - Compute indexer and find the nearest index value if no exact match
- Python Pandas - Get integer location for requested label and find the previous index value if no exact match
- Python Pandas - Get integer location for requested label and find the nearest index value if no exact match
- Python Pandas - Compute indexer and mask for new index given the current index
- Python Pandas - Compute the slice indexer for input labels
- Python Pandas - Compute indexer and mask for new index even for non-uniquely valued objects
- Python Pandas - Return the label from the index or if not present, the previous one
- Python Pandas - Compute the symmetric difference of two Index objects
- Python Pandas - Compute the symmetric difference of two Index objects and unsort the result
- Python Pandas - Check if the Pandas Index holds Interval objects
- Python Pandas - Check if the index has NaNs
- Python - Return the minimum value of the Pandas Index
- Python - Return the maximum value of the Pandas Index
- Python – Find Product of Index Value and find the Summation
Advertisements