主要内容

Timetables

Time-stamped data in tabular form

timetable是将时间与每一行关联的一种表。像桌子,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, see创建时间表or watch使用时间表管理时间戳记的表格数据.

Functions

expand all

timetable 时间stamped行和不同类型的变量的时间表阵列
timeseries2timetable Converttimeseriesobjects to timetable
桌子2timetable 将表转换为时间表
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 打印表，时间表或分类阵列的摘要

Basic Import and Export

readtimetable Create timetable from file
writetimetable 编写时间表

定义导入规则

detectImportOptions 基于文件内容的创建导入选项
电子表格importoptions Import options object for Spreadsheets
getvaropts Get variable import options
setvaropts 设置变量导入选项
setvartype Set variable data types
preview 使用导入选项从文件预览八行

Parquet Files

parquetRead Read columnar data from a Parquet file
parquetwrite 将柱状数据写入木板文件
parquetinfo 获取有关镶木木文件的信息
头 获取顶部的桌子，时间表或高阵列
tail 获取桌子，时间表或高阵列的底部行
unique 数组中的唯一值
时间范围 Time range for timetable row subscripting
withtol Time tolerance for timetable row subscripting
vartype 订阅到表或按变量类型的时间表
sor Sort rows of matrix or table
退休 在时间表中重新采样或汇总数据，并解决重复或不规则时间
synchronize 将时间表同步到通用时间矢量，并从输入时间表重新采样或聚集数据
落后 Time-shift data in timetable
包含 Determine if timetable row times contain specified time range
重叠 Determine if timetable row times overlap specified time range
withinrange Determine if timetable row times are within specified time range
是规则 Determine if input times are regular with respect to time or calendar unit
任何人 Determine if any array element is missing
ismissing Find missing values
standardizeMissing 插入标准缺失值
rmmissing Remove missing entries
fillmissing 填写缺失值
stackedplot Stacked plot of several variables with common x-axis

Apps

Data Cleaner Preprocess and organize column-oriented data

Live Editor Tasks

保留时间表 Resample or aggregate timetable data in the Live Editor
Synchronize Timetables 在实时编辑器中的新时间向量和将时间表结合到现场编辑器中
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
堆栈表变量 将来自多个表变量的值结合到实时编辑器中的一个表变量
解开表变量 Distribute values from one table variable to multiple table variables in the Live Editor

Topics

Related Information