Timetables

Time-stamped data in tabular form

timetable is a type of table that associates a time with each row. Like table, the timetable data type can store column-oriented data variables that have different data types and sizes, as long as they have the same number of rows. In addition, timetables provide time-specific functions to align, combine, and perform calculations with one or more timetables. For more information, see Create Timetables or watch Managing Time-Stamped Tabular Data with Timetables.

Functions

timetable Create timetable from workspace variables
retime Resample or aggregate data in timetable, and resolve duplicate or irregular times
synchronize Synchronize timetables to common time vector, and resample or aggregate data from input timetables
lag Time-shift data in timetable
table2timetable Convert table to timetable
array2timetable Convert array to timetable
timetable2table Convert timetable to table
istimetable Determine if input is timetable
isregular Determine whether times in timetable are regular
timerange Time range for timetable row subscripting
withtol Time tolerance for timetable row subscripting
vartype Subscript into table or timetable by variable type
rmmissing Remove missing entries
issorted Determine whether array is sorted
sortrows Sort rows of array, table, or timetable
unique Unique values in array

Properties

Timetable Properties Access and modify timetable metadata properties

Topics

Create Timetables

Create timetables to associate times with rows of data. Adjust data in a timetable to a different set of times, and synchronize data in multiple timetables.

Clean Timetable with Missing, Duplicate, or Nonuniform Times

Clean timetables that have missing, duplicate, or irregular times, and produce regular timetables.

Resample and Aggregate Data in Timetable

Resample or aggregate data in a timetable to a new vector of row times.

Combine Timetables and Synchronize Their Data

Combine timetables by concatenation or by synchronizing their data to a common time vector.

Select Timetable Data by Row Time and Variable Type

Subscript into a timetable with the timerange, withtol, or vartype functions.

Access Data in a Table

Indexing into tables with parentheses, curly braces, and dot notation has different results. You can use indexing to create a table that is a subset of a larger table or to create an array from data in a table.

Using Row Labels in Table and Timetable Operations

Some table and timetable functions do not allow you to specify row labels and data variables together as key variables, grouping variables, and so on. To join, group, or stack using row labels in combination with variables, first copy the row labels to a new variable, or in the case of a timetable, convert it to a table.

Was this topic helpful?