____________________
______
______
14-Jan-2016 09:00:00
97.96
95.85
13-Jan-2016 09:00:00
100.32
100.58
12-Jan-2016 09:00:00
100.55
99
11-Jan-2016 09:00:00
98.97
97.91
08-Jan-2016 09:00:00
98.55
99.88
08-Jan-2016 09:00:00
98.55
99.88
07-Jan-2016 09:00:00
98.68
100.5
06-Jan-2016 09:00:00
100.56
101.13
05-Jan-2016 09:00:00
105.75
102.89
04-Jan-2016 09:00:00
102.61
101.95
Concatenate Timetables Horizontally
You also can concatenate timetables horizontally. The timetables must have the same row times and
different variables.
Display the timetable opOtherStocks. The timetable has the same row times as opWeek1, but
variables for different stocks.
opOtherStocks
opOtherStocks=5×2 timetable
Time
MSFT
TWTR
____________________
_____
_____
08-Jan-2016 09:00:00
52.37
20.51
07-Jan-2016 09:00:00
52.7
21
06-Jan-2016 09:00:00
54.32
21.62
05-Jan-2016 09:00:00
54.93
22.79
04-Jan-2016 09:00:00
54.32
22.64
Concatenate opWeek1 and opOtherStock. The output timetable has one set of row times and the
variables from both timetables.
op = [opWeek1 opOtherStocks]
op=5×4 timetable
Time
AAPL
FB
MSFT
TWTR
____________________
______
______
_____
_____
08-Jan-2016 09:00:00
98.55
99.88
52.37
20.51
07-Jan-2016 09:00:00
98.68
100.5
52.7
21
06-Jan-2016 09:00:00
100.56
101.13
54.32
21.62
05-Jan-2016 09:00:00
105.75
102.89
54.93
22.79
04-Jan-2016 09:00:00
102.61
101.95
54.32
22.64
Synchronize Timetables and Indicate Missing Data
Load air quality data and weather measurements from two different timetables and synchronize
them. The dates of the measurements range from November 15, 2015, to November 19, 2015. The air
quality data come from a sensor inside a building, while the weather measurements come from
sensors outside.
Combine Timetables and Synchronize Their Data
10-9