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 pdimport pandas as pd# Create the first TimedeltaIndex objecttidx = pd.TimedeltaIndex(start ='1 days 02:00:12.001124', periods = 5, freq ='N', name ='Koala')# Print the TimedeltaIndex objectprint(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 labeltidx.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 pdimport pandas as pd# Create the TimedeltaIndex objecttidx = pd.TimedeltaIndex(data =['06:05:01.000030', '+23:59:59.999999', '22 day 2 min 3us 10ns'])# Print the TimedeltaIndex objectprint(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 labeltidx.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.
