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.

Funktionen

alle erweitern

timetableTables for time series data, with timestamped rows and variables of different types
timeseries2timetableConvert timeseries objects to timetable (Seit R2021b)
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 (Seit R2021b)
summaryPrint summary of table, timetable, or categorical array

Basic Import and Export

readtimetableCreate timetable from file (Seit R2019a)
writetimetableWrite timetable to file (Seit R2019a)

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 (Seit R2019a)
parquetwriteWrite columnar data to Parquet file (Seit R2019a)
parquetinfoGet information about Parquet file (Seit R2019a)
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 (Seit R2022a)
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 (Seit R2020a)
overlapsrangeDetermine if timetable row times overlap specified time range (Seit R2020a)
withinrangeDetermine if timetable row times are within specified time range (Seit R2020a)
isregularDetermine if input times are regular with respect to time or calendar unit
eventtableEvent table (Seit R2023a)
extracteventsExtract event table from subset of timetable data (Seit R2023a)
eventfilterCreate event filter for selecting timetable rows (Seit R2023a)
synceventsAdd and synchronize variables from attached event table to timetable (Seit R2023a)
anymissingDetermine if any array element is missing (Seit R2022a)
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 (Seit R2022a)

Live Editor Tasks

Retime TimetableResample or aggregate timetable data in the Live Editor (Seit R2020a)
Synchronize TimetablesRetime and combine timetables to new time vector in the Live Editor (Seit R2020a)
Compute by GroupSummarize, transform, or filter by group in the Live Editor (Seit R2021b)
Pivot TableSummarize tabular data in pivoted table in the Live Editor (Seit R2023b)

Themen