Main Content


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.


expand all

timetableTimetable array with time-stamped rows and variables of different types
timeseries2timetableConvert timeseries objects to timetable
table2timetableConvert table to timetable
array2timetableConvert homogeneous array to timetable
timetable2tableConvert timetable to table
istimetableDetermine if input is timetable
istabularDetermine if input is table or timetable
summaryPrint summary of table, timetable, or categorical array

Basic Import and Export

readtimetableCreate timetable from file
writetimetableWrite timetable to file

Define Import Rules

detectImportOptionsCreate import options based on file content
spreadsheetImportOptionsImport options object for Spreadsheets
getvaroptsGet variable import options
setvaroptsSet variable import options
setvartypeSet variable data types
previewPreview eight rows from file using import options

Parquet Files

parquetreadRead columnar data from a Parquet file
parquetwriteWrite columnar data to Parquet file
parquetinfoGet information about Parquet file
headGet top rows of table, timetable, or tall array
tailGet bottom rows of table, timetable, or tall array
uniqueUnique values in array
timerangeTime range for timetable row subscripting
withtolTime tolerance for timetable row subscripting
vartypeSubscript into table or timetable by variable type
sortrowsSort rows of matrix or table
retimeResample or aggregate data in timetable, and resolve duplicate or irregular times
synchronizeSynchronize timetables to common time vector, and resample or aggregate data from input timetables
lagTime-shift data in timetable
containsrangeDetermine if timetable row times contain specified time range
overlapsrangeDetermine if timetable row times overlap specified time range
withinrangeDetermine if timetable row times are within specified time range
isregularDetermine if input times are regular with respect to time or calendar unit
ismissingFind missing values
standardizeMissingInsert standard missing values
rmmissingRemove missing entries
fillmissingFill missing values
stackedplotStacked plot of several variables with common x-axis

Live Editor Tasks

Retime TimetableResample or aggregate timetable data in the Live Editor
Synchronize TimetablesRetime and combine timetables to new time vector in the Live Editor
Join TablesCombine two tables using key variables in the Live Editor
Stack Table VariablesCombine values from multiple table variables into one table variable in the Live Editor
Unstack Table VariablesDistribute values from one table variable to multiple table variables in the Live Editor


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.

Featured Examples