Note: This page has been translated by MathWorks. Click here to see

To view all translated materials including this page, select Country from the country navigator on the bottom of this page.

To view all translated materials including this page, select Country from the country navigator on the bottom of this page.

Resample or aggregate data in timetable, and resolve duplicate or irregular times

`TT2 = retime(TT1,newTimeStep,method)`

`TT2 = retime(TT1,'regular',method,'TimeStep',dt)`

`TT2 = retime(TT1,'regular',method,'SampleRate',Fs)`

`TT2 = retime(TT1,newTimes,method)`

`TT2 = retime(TT1,newTimeStep)`

`TT2 = retime(TT1,'regular','TimeStep',dt)`

`TT2 = retime(TT1,'regular','SampleRate',Fs)`

`TT2 = retime(TT1,newTimes)`

`TT2 = retime(___,Name,Value)`

`TT2 = retime(`

returns a timetable that contains the variables from `TT1`

,`newTimeStep`

,`method`

)`TT1`

and
row times that are regularly spaced by the time step
`newTimeStep`

. The `retime`

function
resamples or aggregates data in the variables of `TT1`

using
the function specified by `method`

. You can use
`retime`

to:

Interpolate data values from

`TT1`

at different times.Aggregate data into time bins (for example, to create a timetable containing quarterly means from monthly data).

Remove rows from

`TT1`

that have duplicate row times.Make an irregular timetable into a regular timetable, since

`newTimeStep`

specifies regular row times.

The `newTimeStep`

input argument is a character vector or string that
specifies a predefined time step. For example, when
`newTimeStep`

is `'daily'`

, and
`method`

is `'mean'`

, then
`TT2`

contains the daily means of the data from
`TT1`

.

The first row time of `TT2`

is on the time
step before the earliest row time from `TT1`

. The
row times in `TT2`

cover the range of row times from `TT1`

.
However, `TT2`

might not include any of the actual
row times from `TT1`

, since `TT1`

might
not have any row times that fall on any of the regular row times of `TT2`

.

To interpolate or fill in values in `TT2`

using different
methods for different variables, specify the
`VariableContinuity`

property of `TT1`

.
For more information, see Retime and Synchronize Timetable Variables Using Different Methods.

To resample or aggregate data from multiple timetables, see `synchronize`

.

`TT2 = retime(`

calculates regularly spaced row times using the time step `TT1`

,'regular',`method`

,'TimeStep',`dt`

)`dt`

.
The `dt`

input argument is a scalar duration or calendar
duration, specifying a time step of any size. The row times of
`TT2`

span the range of row times of
`TT1`

.

Use this syntax when the time step is not one of the predefined time steps you can specify as a character vector or string.

`TT2 = retime(`

adjusts the timetable variables data to the time vector
`TT1`

,`newTimes`

,`method`

)`newTimes`

, using the method specified by
`method`

. The `newTimes`

time vector can
be irregular, but it must be a sorted datetime or duration vector and contain
unique values. The times in `newTimes`

become the row times of
`TT2`

.

`TT2 = retime(`

adjusts timetable data using the `TT1`

,`newTimeStep`

)`'fillwithmissing'`

method.
`TT2`

has missing data indicators wherever
`TT2`

has a row time that does not match any row time in
`TT1`

.

If `TT1`

has rows with duplicate row times
and `TT2`

has row times that match the duplicates,
then `TT2`

contains the first row from each group
of rows in `TT1`

with duplicate row times that match.

`TT2 = retime(___,`

adjusts timetable data using additional options specified by one or more
`Name,Value`

)`Name,Value`

pairs. You can use this syntax with the input
arguments of any of the previous syntaxes.