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

timetableTimetable array with time-stamped rows and variables of different types
table2timetableConvert table to timetable
array2timetableConvert homogeneous array to timetable
timetable2tableConvert timetable to table
istimetableDetermine if input is 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
headGet top rows of table, timetable, or tall array
tailGet bottom rows of table, timetable, or tall array
timerangeTime range for timetable row subscripting
withtolTime tolerance for timetable row subscripting
vartypeSubscript into table or timetable by variable type
uniqueUnique values in array
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
isregularDetermine whether times in timetable are regular
ismissingFind missing values
standardizeMissingInsert standard missing values
rmmissingRemove missing entries
fillmissingFill missing values
stackedplotStacked plot of several variables with common x-axis

Properties

expand all

StackedLineChart PropertiesStacked plot appearance and behavior
StackedAxesProperties PropertiesAppearance and behavior of individual axes in stacked plot
StackedLineProperties PropertiesAppearance and behavior of individual lines in stacked plot

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 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.

Featured Examples