Main Content

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.

To find and label events in a timetable, attach an event table to it. For more information, see eventtable.

Functions

expand all

timetableTables for time series data, with timestamped rows and variables of different types
timeseries2timetableConvert timeseries objects to timetable (Since R2021b)
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 (Since R2021b)
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 array or table
tailGet bottom rows of array or table
uniqueUnique values in array
timerangeTime range for timetable row subscripting
withtolTime tolerance for timetable row subscripting
vartypeSubscript into table or timetable by variable type
rowfilterSelectively import rows of interest (Since R2022a)
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 (Since R2020a)
overlapsrangeDetermine if timetable row times overlap specified time range (Since R2020a)
withinrangeDetermine if timetable row times are within specified time range (Since R2020a)
isregularDetermine if input times are regular with respect to time or calendar unit
eventtableEvent table (Since R2023a)
extracteventsExtract event table from subset of timetable data (Since R2023a)
eventfilterCreate event filter for selecting timetable rows (Since R2023a)
synceventsAdd and synchronize variables from attached event table to timetable (Since R2023a)
anymissingDetermine if any array element is missing (Since R2022a)
ismissingFind missing values
standardizeMissingInsert standard missing values
rmmissingRemove missing entries
fillmissingFill missing entries
stackedplotStacked plot of several variables with common x-axis

Apps

Data CleanerPreprocess and organize column-oriented data (Since R2022a)

Live Editor Tasks

Retime TimetableResample or aggregate timetable data in the Live Editor (Since R2020a)
Synchronize TimetablesRetime and combine timetables to new time vector in the Live Editor (Since R2020a)
Compute by GroupSummarize, transform, or filter by group in the Live Editor (Since R2021b)
Pivot TableSummarize tabular data in pivoted table in the Live Editor (Since R2023b)

Topics