How to calculate the hourly data points?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
aa
am 6 Nov. 2020
Kommentiert: Peter Perkins
am 20 Nov. 2020
Hi everyone,
May someone help me here ..
I have a long data in time-date formate i.e. six columns YYYY MM DD HH MM SS. Each time values indicate an observation. I want to calcualte the number of observations per hours. It is importanmt to mentioned that frequency of observations is uneven i.e. 10 or 100 obsservation per hour and no observation for a couple of days. So the output must account the missing time as well wehre there is no observation recorded.
Thank You!
2 Kommentare
KSSV
am 6 Nov. 2020
Let the given date be t1.
Geenerate the dates required from start to end of the data with hourly difference. Let this be t2.
Then get the indices you want from t1 using ismember.
Akzeptierte Antwort
Ameer Hamza
am 6 Nov. 2020
Bearbeitet: Ameer Hamza
am 6 Nov. 2020
Try retime():
T = readtable('data.xlsx');
t = datetime(T.YYYY, T.MM, T.DD, T.HH, T.MM_1, T.SS);
TT = timetable(t, ones(size(t)));
newTT = retime(tt, 'hourly', 'sum');
newT = table(newTT.t, newTT.Var1, 'VariableNames', {'Time', 'count'});
6 Kommentare
Peter Perkins
am 20 Nov. 2020
Ameer solution is the right one, but actually, there's not really any need to turn newTT back into a table. You can leave it as a timetable.
Weitere Antworten (0)
Siehe auch
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!