>> import math
>> math.ceil(1.1)
2
Timedelta('21 days 15:00:00')
>> pd.Timedelta.ceil(df.delta.mean(), freq = 'd')
Timedelta('22 days 00:00:00')
Use Case:
I have a DataFrame with two sets of dates and the difference between them. There are two different ways to get a rounded up number of days, depending if you want a Timedelta or an integer.
Method 1: Integer
>> df.delta.mean()
Timedelta('21 days 15:00:00')
>> df_ex.delta.mean() / pd.Timedelta(days = 1)
21.625
That’s the answer, but also for my purposes, partial days is too fine for my purposes. Dividing a Timedelta by pd.Timedelta(days = 1) will result in an integer.
>> math.ceil(df_ex.delta.mean() / pd.Timedelta(days = 1)) 22
Method 2: Timedelta
>> df.delta.mean()
Timedelta('21 days 15:00:00')
>> pd.Timedelta.ceil(df.delta.mean(), freq = 'd')
Timedelta('22 days 00:00:00')