Python | Pandas TimedeltaIndex.asof

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier.

Pandas TimedeltaIndex.asof() function works on a sorted index, it return the most recent label up to and including the passed label. If the passed label is not found, the function return NaN.

Syntax : TimedeltaIndex.asof(label)
Parameters : 
label : label
Return : Timedelta object

Example #1: Use TimedeltaIndex.asof() function to find the most recent label upto the passed label for the given TimedeltaIndex object. 

Python3

# importing pandas as pd
import pandas as pd

# Create the first TimedeltaIndex object
tidx = pd.TimedeltaIndex(start ='1 days 02:00:12.001124', periods = 5,
                                            freq ='N', name ='Koala')

# Print the TimedeltaIndex object
print(tidx)

Output : 

Now we will use the TimedeltaIndex.asof() function to find the most recent label in the tidx object to ‘1 days 02:00:12.001134’.

Python3

# return the most recent label
tidx.asof('1 days 02:00:12.001134')

Output : 

As we can see in the output, the TimedeltaIndex.asof() function has returned a value which is the most recent value up to the passed label. 

Example #2: Use TimedeltaIndex.asof() function to find the ordering of elements of the given TimedeltaIndex object that would sort the underlying data in the object.

Python3

# importing pandas as pd
import pandas as pd

# Create the TimedeltaIndex object
tidx = pd.TimedeltaIndex(data =['06:05:01.000030',
                                '+23:59:59.999999',
                                '22 day 2 min 3us 10ns'])

# Print the TimedeltaIndex object
print(tidx)

Output : 

Now we will use the TimedeltaIndex.asof() function to find the most recent label in the tidx object to ‘+23:59:59.999999’.

Python3

# return the most recent label
tidx.asof('+23:59:59.999999')

Output : 

As we can see in the output, the TimedeltaIndex.asof() function has returned a value which is the most recent value up to the passed label.