Main Content

Timetables

Time-stamped data in tabular form

timetableis a type of table that associates a time with each row. Liketable,timetabledata 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, seeCreate Timetablesor watchManaging Time-Stamped Tabular Data with Timetables.

Functions

expand all

timetable Timetable array with time-stamped rows and variables of different types
timeseries2timetable Converttimeseriesobjects 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

Basic Import and Export

readtimetable Create timetable from file
writetimetable Write timetable to file

Define Import Rules

detectImportOptions 基于文件内容的创建导入选项
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
head Get top rows of table, timetable, or tall array
tail Get bottom rows of table, timetable, or tall array
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
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
anymissing Determine if any array element is missing
ismissing Find missing values
standardizeMissing Insert standard missing values
rmmissing Remove missing entries
fillmissing Fill missing values
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

Related Information