Finding out the average values per day
19 views (last 30 days)
Show older comments
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 Comments
Answers (1)
Akira Agata
on 16 Apr 2018
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');
0 Comments
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!