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`	Tables for time series data, with timestamped rows and variables of different types
`timeseries2timetable`	Convert `timeseries` objects to timetable (Since R2021b)
`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 (Since R2021b)
`summary`	Data summary

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
`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 (Since R2022a)

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 (Since R2020a)
`overlapsrange`	Determine if timetable row times overlap specified time range (Since R2020a)
`withinrange`	Determine if timetable row times are within specified time range (Since R2020a)
`isregular`	Determine if input times are regular with respect to time or calendar unit

Find and Label Events

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

Missing Values

`anymissing`	Determine if any array element is missing (Since R2022a)
`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 (Since R2022a)

Live Editor Tasks

Retime Timetable	Resample or aggregate timetable data in the Live Editor (Since R2020a)
Synchronize Timetables	Retime and combine timetables to new time vector in the Live Editor (Since R2020a)
Compute by Group	Summarize, transform, or filter by group in the Live Editor (Since R2021b)
Pivot Table	Summarize tabular data in pivoted table in the Live Editor (Since R2023b)

Topics

Create Timetables
Create timetables from input row times and data arrays, by converting arrays, tables, or timeseries arrays, or by importing files with tabular data.
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.

Related Information

Featured Examples

Preprocess and Explore Time-Stamped Data Using timetable

Analyze traffic patterns from sensor data using a timetable to organize and preprocess timestamped data.

Open Live Script

Grouped Calculations in Tables and Timetables

Perform in-place calculations on groups of data in tables and timetables.

Open Live Script

Add Event Table from External Data to Timetable

Add events that come from an external data source to your timestamped data, and analyze and plot the results.

Open Live Script

Find Events in Timetable Using Event Table

Find events in your timestamped data. Mark events on data plots and use them to analyze trends.

Open Live Script

Loma Prieta Earthquake Analysis

Analyze and visualize data contained in a timetable. Calculate and plot earthquake shock wave speed and acceleration over time.

Open Live Script