how to find the hourly average of datetime series
14 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Daniel Abraham
le 28 Juil 2021
Commenté : Daniel Abraham
le 3 Août 2021
Hello everyone. I have a datetime series of this form for about 1 month
Dates =datetime(Dates,'InputFormat','dd-MM-yyyy HH:mm:ss')
The variables in the table
Data.Dates
Data.Records1
Data.Records2
I have data for a month at 3 mins intervals.
I visualized plots for the whole time series but I am having troubles visualizing daily averages. 12 to 12 or something like that.
Is it possible to make daily average in hours from this time series into another table with 3 variables?
Thanks in advance
0 commentaires
Réponse acceptée
Scott MacKenzie
le 28 Juil 2021
Modifié(e) : Scott MacKenzie
le 28 Juil 2021
TT1 = table2timetable(Data);
TT2 = retime(TT1, 'hourly', 'mean'); % hourly averages
TT3 = retime(TT1, 'daily', 'mean'); % daily averages
3 commentaires
Scott MacKenzie
le 29 Juil 2021
That's exactly what this line does:
TT2 = retime(TT1, 'hourly', 'mean');
Of course, the line is terminated with a semicolon, so nothing is actually "seen".
You also state: and daily averages for each day of the week of the datetime series
And that's what the following line does:
TT3 = retime(TT1, 'daily', 'mean');
In your example, you include the name of the weekday. If you want to add the weekday name, then add the following:
[~, name] = weekday(TT3.Var1, 'long');
TT3.Weekday = cellstr(name);
If this isn't what you are looking for, please explain further.
Also, it would help if you post your data.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Dates and Time dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!