Python Pandas - Return the label from the index if all of the labels in the index are later than the passed label

To return the label from the index if all of the labels in the index are later than the passed label, use the index.asof() method in Pandas.

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...
",index)

Return the label from the index. Returns NaN when if all of the labels in the index are later than the passed label −

print("
Get the label from the index...
",index.asof(6))

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...
",index)

# Return the number of elements in the Index
print("
Number of elements in the index...
",index.size)

# Return the label from the index
# Returns NaN when if all of the labels in the index are later than the passed label
print("
Get the label from the index...
",index.asof(6))

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 label from the index...
Nan

AmitDiwan

Updated on 14-Oct-2021 07:30:41

• Related Questions & Answers
• Python Pandas - Return the label from the index or if not present, the previous one
• Python Pandas - Return the Transpose of the index
• Python Pandas - Return whether all elements in the index are True
• Python - Return the minimum value of the Pandas Index
• Python - Return the maximum value of the Pandas Index
• Python Pandas - Return the memory usage of the Index values
• Python Pandas - Return the relative frequency from Index object
• Python Pandas - Make new Index with passed list of labels deleted
• Python Pandas - Return unique values in the index
• Python Pandas - Return the int position of the smallest value in the Index
• Python Pandas - Return the int position of the largest value in the Index
• Python Pandas - Return a list of the Index values
• Python Pandas - Return a sorted copy of the index
• Python Pandas - Return the number of bytes in the underlying Index data
• Python Pandas - Return the Number of elements in the underlying Index data