MATLAB Programming Fundamentals - MathWorks

01:29:36

01:30:00

Resample Timetable with Interpolation

Adjust the data in the timetable with the retime function. Specify an hourly time vector.

Interpolate the timetable data to the new row times.

TT = retime(outdoors,'hourly','spline');

TT(1:5,:)

ans=5×4 timetable

Time Humidity TemperatureF PressureHg

___________________ ________ ____________ __________

2015-11-15 00:00:00 49.001 51.298 29.61

2015-11-15 01:00:00 48.909 51.467 29.61

2015-11-15 02:00:00 48.902 51.51 29.61

2015-11-15 03:00:00 48.9 51.5 29.61

2015-11-15 04:00:00 48.844 51.498 29.611

Resample Timetable with Nearest Neighbor Values

Specify an hourly time vector for TT. For each row in TT, copy values from the

corresponding row in outdoors whose row time is nearest.

TT = retime(outdoors,'hourly','nearest');

TT(1:5,:)

ans=5×4 timetable

Time Humidity TemperatureF PressureHg

___________________ ________ ____________ __________

2015-11-15 00:00:00 49 51.3 29.61

2015-11-15 01:00:00 48.9 51.5 29.61

2015-11-15 02:00:00 48.9 51.5 29.61

2015-11-15 03:00:00 48.9 51.5 29.61

2015-11-15 04:00:00 48.8 51.5 29.61

Aggregate Timetable Data and Calculate Daily Mean

The retime function provides aggregation methods, such as mean. Calculate the daily

means for the data in outdoors.

10 Timetables