ans=5×5 timetable
Time
Humidity_indoors
AirQuality
Humidity_outdoors
TemperatureF
___________________
________________
__________
_________________
____________
2015-11-15 00:00:24
36
80
49
51.3
2015-11-15 01:13:35
36
80
48.919
51.463
2015-11-15 01:30:24
36.23
79.77
48.9
51.5
2015-11-15 02:26:47
37
79
48.9
51.5
2015-11-15 03:00:24
37
80.378
48.9
51.5
Synchronize to Regular Times
Synchronize the timetables to an hourly time vector. The input timetables had irregular row times.
The output timetable has regular row times with one hour as the time step.
ttHourly = synchronize(indoors,outdoors,'hourly','linear');
ttHourly(1:5,:)
ans=5×5 timetable
Time
Humidity_indoors
AirQuality
Humidity_outdoors
TemperatureF
___________________
________________
__________
_________________
____________
2015-11-15 00:00:00
36
80
49
51.299
2015-11-15 01:00:00
36
80
48.934
51.432
2015-11-15 02:00:00
36.634
79.366
48.9
51.5
2015-11-15 03:00:00
37
80.361
48.9
51.5
2015-11-15 04:00:00
36.727
81.453
48.834
51.5
Synchronize the timetables to a 30-minute time step. Specify a regular time step using the
'regular' input argument and the 'TimeStep' name-value pair argument.
ttHalfHour = synchronize(indoors,outdoors,'regular','linear','TimeStep',minutes(30));
ttHalfHour(1:5,:)
ans=5×5 timetable
Time
Humidity_indoors
AirQuality
Humidity_outdoors
TemperatureF
___________________
________________
__________
_________________
____________
2015-11-15 00:00:00
36
80
49
51.299
2015-11-15 00:30:00
36
80
48.967
51.366
2015-11-15 01:00:00
36
80
48.934
51.432
2015-11-15 01:30:00
36.224
79.776
48.9
51.499
2015-11-15 02:00:00
36.634
79.366
48.9
51.5
As an alternative, you can synchronize the timetables to a time vector that specifies half-hour
intervals.
tv = [datetime(2015,11,15):minutes(30):datetime(2015,11,18)];
tv.Format = indoors.Time.Format;
ttHalfHour = synchronize(indoors,outdoors,tv,'linear');
ttHalfHour(1:5,:)
ans=5×5 timetable
Time
Humidity_indoors
AirQuality
Humidity_outdoors
TemperatureF
___________________
________________
__________
_________________
____________
Combine Timetables and Synchronize Their Data
10-11