How can I resample data with multiple time column?

2022 8 8
1 个回答
回答已采纳
更新时间：2022 8 8
4 次查看（30 天）

0 个投票

19 1 1 0 0 0 1009.4 28.9 71.0 0.0 0.0 0.0 0.0
19 1 1 0 0 30 1009.4 28.8 71.0 0.0 0.0 0.0 0.0
19 1 1 0 1 0 1009.4 28.8 70.9 0.0 0.0 0.0 0.0
19 1 1 0 1 30 1009.3 28.8 70.9 0.0 0.0 0.0 0.0
19 1 1 0 2 0 1009.3 28.8 71.0 0.0 0.0 0.0 0.0
Dear matlab experts, I have a time series data. the first six column from the left are time value with YY:MM:DD:HH:MM:SS with space delimited format. I want to resample all value from secondly to daily. Do I need to convert time's column into timetable?

请先登录，再回答此问题。

 采纳的回答

Star Strider
Star Strider 2022-8-8
Ran in:

0 个投票

Ran in:
One approach —
M = [ 19 1 1 0 0 0 1009.4 28.9 71.0 0.0 0.0 0.0 0.0
19 1 1 0 0 30 1009.4 28.8 71.0 0.0 0.0 0.0 0.0
19 1 1 0 1 0 1009.4 28.8 70.9 0.0 0.0 0.0 0.0
19 1 1 0 1 30 1009.3 28.8 70.9 0.0 0.0 0.0 0.0
19 1 1 0 2 0 1009.3 28.8 71.0 0.0 0.0 0.0 0.0];
M(:,1) = M(:,1)+2000;
T1 = array2table(M(:,7:end));
DT = datetime(M(:,1:6));
T1 = addvars(T1,DT,'before','Var1')
T1 = 5×8 table
DT Var1 Var2 Var3 Var4 Var5 Var6 Var7 ____________________ ______ ____ ____ ____ ____ ____ ____ 01-Jan-2019 00:00:00 1009.4 28.9 71 0 0 0 0 01-Jan-2019 00:00:30 1009.4 28.8 71 0 0 0 0 01-Jan-2019 00:01:00 1009.4 28.8 70.9 0 0 0 0 01-Jan-2019 00:01:30 1009.3 28.8 70.9 0 0 0 0 01-Jan-2019 00:02:00 1009.3 28.8 71 0 0 0 0
TT1 = table2timetable(T1)
TT1 = 5×7 timetable
DT Var1 Var2 Var3 Var4 Var5 Var6 Var7 ____________________ ______ ____ ____ ____ ____ ____ ____ 01-Jan-2019 00:00:00 1009.4 28.9 71 0 0 0 0 01-Jan-2019 00:00:30 1009.4 28.8 71 0 0 0 0 01-Jan-2019 00:01:00 1009.4 28.8 70.9 0 0 0 0 01-Jan-2019 00:01:30 1009.3 28.8 70.9 0 0 0 0 01-Jan-2019 00:02:00 1009.3 28.8 71 0 0 0 0
TT1rt = retime(TT1,'daily')
TT1rt = 2×7 timetable
DT Var1 Var2 Var3 Var4 Var5 Var6 Var7 ___________ ______ ____ ____ ____ ____ ____ ____ 01-Jan-2019 1009.4 28.9 71 0 0 0 0 02-Jan-2019 NaN NaN NaN NaN NaN NaN NaN
For this approach, use the readmatrix funciton to import the matrix.
.

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Preprocessing 的更多信息

产品

版本

R2021b

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by