How can I resample data with multiple time column?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Anak Agung Adhi Dermawan
am 8 Aug. 2022
Kommentiert: Star Strider
am 8 Aug. 2022
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 Kommentare
Akzeptierte Antwort
Star Strider
am 8 Aug. 2022
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')
TT1 = table2timetable(T1)
TT1rt = retime(TT1,'daily')
.
2 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!