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

timetableTimetable array with timestamped 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 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
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
eventtableEvent table
extracteventsExtract event table from subset of timetable data
eventfilterCreate event filter for selecting timetable rows
synceventsAdd and synchronize variables from attached event table to timetable
anymissingDetermine if any array element is missing
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

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
Compute by GroupSummarize, transform, or filter by group 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

Topics