Python Pandas - Return a new Timedelta with hourly ceiling resolution

To return a new Timedelta ceiled to this resolution, use the timedelta.ceil() method. For hourly ceiling resolution, set the freq parameter to the value H.

At first, import the required libraries −

import pandas as pd

TimeDeltas is Python’s standard datetime library uses a different representation timedelta’s. Create a Timedelta object

timedelta = pd.Timedelta('6 days 11 hours 1 min 30 s')

Display the Timedelta

print("Timedelta...\n", timedelta)

Return the ceiled Timestamp with hourly ceiling resolution

timedelta.ceil(freq='H')

Example

Following is the code

import pandas as pd

# TimeDeltas is Python’s standard datetime library uses a different representation timedelta’s
# create a Timedelta object
timedelta = pd.Timedelta('6 days 11 hours 1 min 30 s')

# display the Timedelta
print("Timedelta...\n", timedelta)

# return the ceiled Timestamp
# with hourly ceiling resolution
res = timedelta.ceil(freq='H')

# display the ceiled Timestamp
print("\nTimedelta (hourly ceiled)...\n", res)

Output

This will produce the following code

Timedelta...
6 days 11:01:30

Timedelta (hourly ceiled)...
6 days 12:00:00

Arnab Chakraborty

Updated on: 14-Oct-2021

46 Views

Kickstart Your Career

Get certified by completing the course

Get Started