MATLAB Programming Fundamentals - MathWorks

Create Timetables

This example shows how to create a timetable, combine timetables, and adjust the data

from multiple timetables to a common time vector. The common time vector can contain

the times from either or both timetables, or it can be an entirely new time vector that you

specify. The example shows how to compute and display a daily mean for weather

measurements contained in different timetables.

A timetable is a type of table that associates a time with each row. A timetable can store

column-oriented data variables that have different data types and sizes, so long as each

variable has the same number of rows. In addition, timetables provide time-specific

functions to combine, subscript into, and adjust their data.

Import Timetables from Files

Load air quality data and weather measurements into two different timetables. 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.

Read the air quality data from a table with the readtable function. Then convert it from

a table to a timetable with the table2timetable function. The readtable function

returns a table only, not a timetable.

indoors = readtable('indoors.csv');

indoors = table2timetable(indoors);

You also can create a timetable from an M-by-N array with the array2timetable

function, or from workspace variables with the timetable function.

Display the first five rows of indoors. Each row of the timetable has a time that labels

that row of data.

indoors(1:5,:)

ans=5×3 timetable

Time Humidity AirQuality

___________________ ________ __________

2015-11-15 00:00:24 36 80

2015-11-15 01:13:35 36 80

2015-11-15 02:26:47 37 79

2015-11-15 03:39:59 37 82

10 Timetables