Timetables

Données tabulaires horodatées

Le type de table timetable associe une heure à chaque ligne. Tout comme table, le type de données timetable peut stocker des variables orientées colonnes comportant le même nombre de lignes. Toutes les fonctions de table peuvent être utilisées avec des timetables. Ces dernières proposent en outre des fonctions temporelles permettant d’aligner et de combiner des timetables et d’effectuer des calculs avec une ou plusieurs d’entre elles. Pour plus d’informations, consultez Create Timetables ou regardez la vidéo Managing Time-Stamped Tabular Data with Timetables (Gérer des données tabulaires horodatées avec les timetables).

Pour trouver et labelliser les événements dans une timetable, attachez-lui une table d’événements (eventtable). Pour plus d’informations, consultez eventtable.

Fonctions

développer tout

Créer des timetables et convertir le type

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

Lire et écrire des fichiers

Importation et exportation de base

`readtimetable`	Create timetable from file
`writetimetable`	Write timetable to file

Définir des règles d’importation

`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

Fichiers Parquet

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

Indice par ligne, plage temporelle ou type de variable

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

Trier, décaler et synchroniser

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

Trouver et labelliser des événements

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

Valeurs manquantes

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

Diagramme à barres empilées

stackedplot Stacked plot of several variables with common x-axis

Applications

Data Cleaner

Preprocess and organize column-oriented data (depuis R2022a)

Tâches du Live Editor

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

Rubriques

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.