Python Pandas - Perform ceil operation on the TimeDeltaIndex object with minutely frequency

To perform ceil operation on the TimeDeltaIndex with minutely frequency, use the TimeDeltaIndex.ceil() method. For minutely frequency, use the freq parameter with value 'T'.

What is Ceil Operation?

The ceil() operation rounds up each TimeDelta to the nearest specified frequency boundary. For minutely frequency ('T'), it rounds up to the next minute boundary.

Syntax

TimedeltaIndex.ceil(freq)

Parameters

freq ? The frequency to round up to. Use 'T' for minutely frequency.

Example

Following is the complete example ?

import pandas as pd

# Create a TimeDeltaIndex object
# We have set the timedelta-like data using the 'data' parameter
tdIndex = pd.TimedeltaIndex(data =['4 day 8h 20min 35us 45ns', '+17:42:19.999999',
'9 day 3h 08:16:02.000055', '+22:35:25.000075'])

# Display TimedeltaIndex
print("TimedeltaIndex...\n", tdIndex)

# Return a dataframe of the components of TimeDeltas
print("\nThe Dataframe of the components of TimeDeltas...\n", tdIndex.components)

# Ceil operation on TimeDeltaIndex date with minutely frequency
# For minutely frequency, we have used 'T'
print("\nPerforming Ceil operation with minutely frequency...\n",
tdIndex.ceil(freq='T'))

Output

This will produce the following output ?

TimedeltaIndex...
 TimedeltaIndex(['4 days 08:20:00.000035045', '0 days 17:42:19.999999',
                '9 days 11:16:02.000055', '0 days 22:35:25.000075'],
               dtype='timedelta64[ns]', freq=None)

The Dataframe of the components of TimeDeltas...
   days  hours  minutes  seconds  milliseconds  microseconds  nanoseconds
0     4      8       20        0             0            35           45
1     0     17       42       19           999           999            0
2     9     11       16        2             0            55            0
3     0     22       35       25             0            75            0

Performing Ceil operation with minutely frequency...
 TimedeltaIndex(['4 days 08:21:00', '0 days 17:43:00', '9 days 11:17:00',
                '0 days 22:36:00'],
               dtype='timedelta64[ns]', freq=None)

How It Works

The ceil operation rounds up each TimeDelta value:

• '4 days 08:20:00.000035045' becomes '4 days 08:21:00' (rounded up to next minute)
• '0 days 17:42:19.999999' becomes '0 days 17:43:00' (rounded up to next minute)
• '9 days 11:16:02.000055' becomes '9 days 11:17:00' (rounded up to next minute)

Conclusion

Use TimedeltaIndex.ceil(freq='T') to round up TimeDelta values to the nearest minute boundary. This operation is useful for time-based data aggregation and analysis.