Finding out the average values per day

Question

Mark Rodger 2018-4-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/393648-finding-out-the-average-values-per-day

回答： Akira Agata 2018-4-16

I've got a 7536x2 table that shows hourly values per day over 10 months. I would like to find out the average value for each day of the year and plot it. Any thoughts?

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

请先登录，再进行评论。

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

Answer 1

Akira Agata 2018-4-16

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/393648-finding-out-the-average-values-per-day#answer_315297

在 MATLAB Online 中打开

Like this?

% Sample Data (Hourly values per day over 10 months)
Time = [datetime(2018,1,1):hours(1):datetime(2018,10,1)]';
Data = rand(size(Time));
YourData = table(Time,Data);
% Convert to timetable
TT = table2timetable(YourData);
% Calculate average value per day
DailyAvg = retime(TT,'daily','mean');