How can I resample data with multiple time column?

Question

Anak Agung Adhi Dermawan 2022-8-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1775785-how-can-i-resample-data-with-multiple-time-column

评论： Star Strider 2022-8-8

采纳的回答： Star Strider

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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2022-8-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1775785-how-can-i-resample-data-with-multiple-time-column#answer_1022870

在 MATLAB Online 中打开

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 