pandas.Timestamp.round#

Timestamp.round(freq,ambiguous='raise',nonexistent='raise')#

Round the Timestamp to the specified resolution.

Parameters:

freqstr

Frequency string indicating the rounding resolution.

ambiguousbool or {‘raise’, ‘NaT’}, default ‘raise’

The behavior is as follows:

• bool contains flags to determine if time is dst or not (notethat this flag is only applicable for ambiguous fall dst dates).

• ‘NaT’ will return NaT for an ambiguous time.

• ‘raise’ will raise an AmbiguousTimeError for an ambiguous time.

nonexistent{‘raise’, ‘shift_forward’, ‘shift_backward, ‘NaT’, timedelta}, default ‘raise’

A nonexistent time does not exist in a particular timezonewhere clocks moved forward due to DST.

• ‘shift_forward’ will shift the nonexistent time forward to theclosest existing time.

• ‘shift_backward’ will shift the nonexistent time backward to theclosest existing time.

• ‘NaT’ will return NaT where there are nonexistent times.

• timedelta objects will shift nonexistent times by the timedelta.

• ‘raise’ will raise an NonExistentTimeError if there arenonexistent times.

Returns:

a new Timestamp rounded to the given resolution offreq

Raises:

ValueError if the freq cannot be converted

Notes

If the Timestamp has a timezone, rounding will take place relative to thelocal (“wall”) time and re-localized to the same timezone. When roundingnear daylight savings time, usenonexistent andambiguous tocontrol the re-localization behavior.

Examples

Create a timestamp object:

>>>ts=pd.Timestamp('2020-03-14T15:32:52.192548651')

A timestamp can be rounded using multiple frequency units:

>>>ts.round(freq='h')# hourTimestamp('2020-03-14 16:00:00')

>>>ts.round(freq='min')# minuteTimestamp('2020-03-14 15:33:00')

>>>ts.round(freq='s')# secondsTimestamp('2020-03-14 15:32:52')

>>>ts.round(freq='ms')# millisecondsTimestamp('2020-03-14 15:32:52.193000')

freq can also be a multiple of a single unit, like ‘5min’ (i.e. 5 minutes):

>>>ts.round(freq='5min')Timestamp('2020-03-14 15:35:00')

or a combination of multiple units, like ‘1h30min’ (i.e. 1 hour and 30 minutes):

>>>ts.round(freq='1h30min')Timestamp('2020-03-14 15:00:00')

Analogous forpd.NaT:

>>>pd.NaT.round()NaT

When rounding near a daylight savings time transition, useambiguous ornonexistent to control how the timestamp should be re-localized.

>>>ts_tz=pd.Timestamp("2021-10-31 01:30:00").tz_localize("Europe/Amsterdam")

>>>ts_tz.round("h",ambiguous=False)Timestamp('2021-10-31 02:00:00+0100', tz='Europe/Amsterdam')

>>>ts_tz.round("h",ambiguous=True)Timestamp('2021-10-31 02:00:00+0200', tz='Europe/Amsterdam')