Python | Pandas TimedeltaIndex.asof
Last Updated :
09 Sep, 2021
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
import pandas as pd
tidx = pd.TimedeltaIndex(start = '1 days 02:00:12.001124' , periods = 5 ,
freq = 'N' , name = 'Koala' )
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
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
import pandas as pd
tidx = pd.TimedeltaIndex(data = [ '06:05:01.000030' ,
'+23:59:59.999999' ,
'22 day 2 min 3us 10ns' ])
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
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.
Share your thoughts in the comments
Please Login to comment...