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. 

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’.

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.

Output : 
 

Now we will use the TimedeltaIndex.asof() function to find the most recent label in the tidx object to ‘+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.