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 the same number of rows. All table functions work with timetables. 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

expand all

Create Timetables and Convert Type

`timetable`	Timetable array with time-stamped rows and variables of different types
`table2timetable`	Convert table to timetable
`array2timetable`	Convert homogeneous array to timetable
`timetable2table`	Convert timetable to table
`istimetable`	Determine if input is timetable
`summary`	Print summary of table, timetable, or categorical array

Read and Write Files

Basic Import and Export

`readtimetable`	Create timetable from file
`writetimetable`	Write timetable to file

Define Import Rules

`detectImportOptions`	Create import options based on file content
`spreadsheetImportOptions`	Import options object for Spreadsheets
`getvaropts`	Get variable import options
`setvaropts`	Set variable import options
`setvartype`	Set variable data types
`preview`	Preview eight rows from file using import options

Select Part of Timetable

`head`	Get top rows of table, timetable, or tall array
`tail`	Get bottom rows of table, timetable, or tall array
`timerange`	Time range for timetable row subscripting
`withtol`	Time tolerance for timetable row subscripting
`vartype`	Subscript into table or timetable by variable type
`unique`	Unique values in array

Sort, Shift, and Synchronize

`sortrows`	Sort rows of matrix or table
`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
`containsrange`	Determine if timetable row times contain specified time range
`overlapsrange`	Determine if timetable row times overlap specified time range
`withinrange`	Determine if timetable row times are within specified time range
`isregular`	Determine if timetable is regular with respect to time or calendar unit

Missing Values

`ismissing`	Find missing values
`standardizeMissing`	Insert standard missing values
`rmmissing`	Remove missing entries
`fillmissing`	Fill missing values

Stacked Plot

stackedplot Stacked plot of several variables with common x-axis

Live Editor Tasks

Retime Timetable	Resample or aggregate timetable data in the Live Editor
Synchronize Timetables	Retime and combine timetables to new time vector in the Live Editor
Join Tables	Combine two tables using key variables in the Live Editor
Stack Table Variables	Combine values from multiple table variables into one table variable in the Live Editor
Unstack Table Variables	Distribute values from one table variable to multiple table variables in the Live Editor

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.

Access Data in Tables

Indexing into tables with parentheses, dot notation, and curly braces accesses table data in different ways. 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.

Related Information

Tables

Represent Dates and Times in MATLAB

Time Series Objects and Collections

Featured Examples

Preprocess and Explore Time-stamped Data Using timetable

Analyze bicycle traffic patterns from sensor data using the timetable data container to organize and preprocess time-stamped data. The data come from sensors on Broadway Street in Cambridge, MA. The City of Cambridge provides public access to the full data set at the Cambridge Open Data site.

Open Live Script

Documentation