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

Create Timetables and Convert Type

`timetable`	Timetable array with timestamped rows and variables of different types
`timeseries2timetable`	Convert `timeseries` objects to timetable
`table2timetable`	Convert table to timetable
`array2timetable`	Convert homogeneous array to timetable
`timetable2table`	Convert timetable to table
`istimetable`	Determine if input is timetable
`istabular`	Determine if input is table or 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

Parquet Files

`parquetread`	Read columnar data from a Parquet file
`parquetwrite`	Write columnar data to Parquet file
`parquetinfo`	Get information about Parquet file

Subscript by Rows, Time Range, or Variable Type

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

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 input times are regular with respect to time or calendar unit

Find and Label Events

`eventtable`	Event table
`extractevents`	Extract event table from subset of timetable data
`eventfilter`	Create event filter for selecting timetable rows
`syncevents`	Add and synchronize variables from attached event table to timetable

Missing Values

`anymissing`	Determine if any array element is missing
`ismissing`	Find missing values
`standardizeMissing`	Insert standard missing values
`rmmissing`	Remove missing entries
`fillmissing`	Fill missing entries

Stacked Plot

stackedplot Stacked plot of several variables with common x-axis

Apps

Data Cleaner

Preprocess and organize column-oriented data

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
Compute by Group	Summarize, transform, or filter by group 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.
Direct Calculations on Tables and Timetables
You can perform calculations directly on tables and timetables without indexing to extract their data. All the variables in your tables and timetables must have data types that support calculations.
Resample and Aggregate Data in Timetable

Resample or aggregate data in a timetable to a new vector of row times.
- Combine Timetables and Synchronize Their Data
- Retime and Synchronize Timetable Variables Using Different Methods
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.