文档

创建时间表

此示例演示如何创建时间表、组合时间表以及将多个时间表中的数据调整为公共时间向量。公共时间向量可以包含其中一个或两个时间表中的时间,也可以是您指定的全新时间向量。此示例演示如何计算和显示天气测量的日平均值包含在不同时间表中的时间。

时间表是一种将时间与每行关联的表。时间表可以存储具有不同数据类型和大小的面向列的数据变量,只要每个变量具有相同的行数。此外,时间表还提供特定于时间的函数,用于组合、下标和调整其数据。

从文件导入时间表

将空气质量数据和天气测量数据加载到两个不同的时间表中。测量日期为2015年11月15日至2015年11月19日。空气质量数据来自建筑物内的传感器,而天气测量数据来自建筑物外的传感器。

从带有可读函数。然后使用表2可计量功能可读函数只返回一个表,而不是时间表。

室内=可读(“室内.csv”); 室内=表2可计量(室内);

您还可以使用安排时间表函数,或使用时间表作用

显示文件的前五行在室内.时间表的每一行都有标记该行数据的时间。

室内(1:5,:)
ans=5×3时刻表时间湿度空气质量

加载带有天气测量值的时间表。显示前五行天气测量值在户外.

负载在户外户外(1:5,:)
ans=5×4时刻表中国UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU\\\\\\\\\06:00:2448.751.529.6

同步时间表

时间表,在室内在户外,包含在不同时间在建筑物内外进行的不同测量。使用使同步作用

tt=同步(室内、室外);tt(1:5,:)
ans=5×6时刻表该网站的UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU2015-11-15 00:00:24 36 80 49 51.3 29.61 2015-11-15 01:13:35 36 80楠楠2015-11-15 01:30:24楠楠48.9 51.5 29.61 2015-11-15 02:26:47 37 79楠楠楠2015-11-15 03:00:24楠楠南48.951.529.61

输出时间表,tt包含两个时间表中的所有时间。使同步将缺少的数据指示器放置在没有数据值的位置tt. 当两个输入时间表具有相同名称的变量时,例如湿度,使同步重命名这两个变量并将其添加到输出时间表中。

再次同步时间表,这次使用线性插值填充缺失的数据值。

ttLinear=同步(室内、室外、,“联盟”,“线性”);tt线性(1:5,:)
ans=5×6时刻表该网站的UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU2015-11-15 00:00:24 36 80 49 51.3 29.61 2015-11-15 01:13:35 36 80 48.919 51.463 29.61 2015-11-15 01:30:24 36.23 79.77 48.9 51.5 29.61 2015-11-15 02:26:47 37 79 48.9 51.5 29.61 2015-11-15 03:00:24 37 80.378 48.9 51.5 29.61

在一个时间表中调整数据

您还可以将单个时间表中的数据调整为新的时间向量。计算中变量的平均值线性超过六小时的时间间隔休息时间函数。如果有行调整数据后,使用RMM缺失作用

电视=[日期时间(2015,11,15):小时(6):日期时间(2015,11,18)];ttHourly=重定时(ttLinear,tv,“中庸”);ttHourly=rmmissing(ttHourly);

绘图时间表数据

规范化中的数据每小时到时间表中每个变量的平均值。绘制这些测量值的平均日值。您可以使用变量访问变量的时间表的属性。ttp.变量返回与相同的变量TTH{:,:}.

ttMeanVars=ttHourly.Variables./mean(ttHourly.Variables);绘图(ttHourly.Time,ttMeanVars);图例(ttHourly.Properties.VariableNames,“口译员”,“没有”); xlabel(“时间”); 伊拉贝尔(“标准化天气测量”);头衔(“平均每日天气趋势”);

另见

|||||

相关话题