Python Pandas - Return a new Timedelta floored to this resolution

To return a new Timedelta floored to a specific resolution, use the timedelta.floor() method. The flooring operation truncates the time components to the nearest lower boundary of the specified frequency.

Syntax

Timedelta.floor(freq)

Parameters

The freq parameter specifies the frequency to floor to. Common values include:

• 'D' - Days
• 'H' - Hours
• 'min' - Minutes
• 'S' - Seconds

Example - Floor to Days

Floor a Timedelta to the nearest day ?

import pandas as pd

# Create a Timedelta object
timedelta = pd.Timedelta('6 days 1 min 30 s')
print("Original Timedelta:", timedelta)

# Floor to days frequency
floored = timedelta.floor(freq='D')
print("Floored to days:", floored)

Original Timedelta: 6 days 00:01:30
Floored to days: 6 days 00:00:00

Example - Floor to Hours

Floor the same Timedelta to hours ?

import pandas as pd

timedelta = pd.Timedelta('2 days 5 hours 30 min')
print("Original Timedelta:", timedelta)

# Floor to hours
floored_hours = timedelta.floor(freq='H')
print("Floored to hours:", floored_hours)

Original Timedelta: 2 days 05:30:00
Floored to hours: 2 days 05:00:00

Multiple Frequency Examples

Compare flooring with different frequencies ?

import pandas as pd

td = pd.Timedelta('1 day 3 hours 45 min 20 s')
print("Original:", td)
print("Floor to days:", td.floor('D'))
print("Floor to hours:", td.floor('H'))
print("Floor to minutes:", td.floor('min'))

Original: 1 days 03:45:20
Floor to days: 1 days 00:00:00
Floor to hours: 1 days 03:00:00
Floor to minutes: 1 days 03:45:00

Conclusion

The floor() method truncates Timedelta values to a specified frequency boundary. Use 'D' for days, 'H' for hours, or 'min' for minutes based on your precision needs.