Orari

Dati temporali in forma tabellare

timetable è un tipo di tabella che associa un orario a ogni riga. Come table, il tipo di dati timetable può memorizzare variabili di dati orientate alle colonne che hanno lo stesso numero di righe. Tutte le funzioni della tabella funzionano con gli orari. Inoltre, gli orari forniscono funzioni specifiche per l'orario per allineare, abbinare ed eseguire calcoli con uno o più orari. Per maggiori informazioni, vedere Create Timetables o guardare Managing Time-Stamped Tabular Data with Timetables (Gestione dei dati tabellari temporali con orari).

Per trovare ed etichettare gli eventi in un orario, allegarci una tabella degli eventi. Per maggiori informazioni, vedere eventtable.

Funzioni

espandi tutto

Creazione di orari e conversione del tipo

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

Lettura e scrittura di file

Importazione ed esportazione di base

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

Definizione delle regole di importazione

`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

File Parquet

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

Sottoscrizione per righe, intervallo di tempo o tipo di variabile

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

Ordinamento, spostamento e sincronizzazione

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

Ricerca ed etichettatura di eventi

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

Valori mancanti

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

Grafico sovrapposto

stackedplot Stacked plot of several variables with common x-axis

App

Data Cleaner

Preprocess and organize column-oriented data (Da R2022a)

Attività di Live Editor

Ritemporizzare l'orario	Resample or aggregate timetable data in the Live Editor (Da R2020a)
Sincronizzare gli orari	Retime and combine timetables to new time vector in the Live Editor (Da R2020a)
Calcolare per gruppo	Summarize, transform, or filter by group in the Live Editor (Da R2021b)
Tabella Pivot	Summarize tabular data in pivoted table in the Live Editor (Da R2023b)

Argomenti

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.