Python Pandas - Round the Timedelta with daily frequency

To round a Timedelta with daily frequency resolution, use the round() method on a Pandas Timedelta object. Set the frequency parameter to 'D' for daily rounding.

Syntax

timedelta.round(freq='D')

Where freq='D' specifies daily frequency for rounding.

Creating a Timedelta Object

First, create a Timedelta object with various time components ?

import pandas as pd

# Create a Timedelta object with days, hours, minutes, seconds, milliseconds, and nanoseconds
timedelta = pd.Timedelta('2 days 11 hours 22 min 25 s 50 ms 45 ns')
print("Original Timedelta:")
print(timedelta)

Original Timedelta:
2 days 11:22:25.050000045

Rounding with Daily Frequency

Use the round() method with freq='D' to round to the nearest day ?

import pandas as pd

timedelta = pd.Timedelta('2 days 11 hours 22 min 25 s 50 ms 45 ns')
print("Original Timedelta:")
print(timedelta)

# Round to daily frequency
rounded_timedelta = timedelta.round(freq='D')
print("\nTimedelta (daily rounded):")
print(rounded_timedelta)

Original Timedelta:
2 days 11:22:25.050000045

Timedelta (daily rounded):
2 days 00:00:00

How Rounding Works

When rounding with daily frequency, the time components (hours, minutes, seconds) are evaluated. If the time is 12 hours or more, it rounds up to the next day; otherwise, it rounds down ?

import pandas as pd

# Example 1: Less than 12 hours - rounds down
td1 = pd.Timedelta('2 days 5 hours')
print("2 days 5 hours rounded:", td1.round(freq='D'))

# Example 2: Exactly 12 hours - rounds up  
td2 = pd.Timedelta('2 days 12 hours')
print("2 days 12 hours rounded:", td2.round(freq='D'))

# Example 3: More than 12 hours - rounds up
td3 = pd.Timedelta('2 days 18 hours')
print("2 days 18 hours rounded:", td3.round(freq='D'))

2 days 5 hours rounded: 2 days 00:00:00
2 days 12 hours rounded: 3 days 00:00:00
2 days 18 hours rounded: 3 days 00:00:00

Conclusion

Use timedelta.round(freq='D') to round Timedelta objects to the nearest day. Times of 12 hours or more round up to the next day, while less than 12 hours round down.