how to find the hourly average of datetime series
12 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Scott MacKenzie
2021-7-28
编辑:Scott MacKenzie
2021-7-28
TT1 = table2timetable(Data);
TT2 = retime(TT1, 'hourly', 'mean'); % hourly averages
TT3 = retime(TT1, 'daily', 'mean'); % daily averages
3 个评论
Scott MacKenzie
2021-7-29
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.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!