Finding out the average values per day

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?

Antworten (1)

Akira Agata
Akira Agata am 16 Apr. 2018

2 Stimmen

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');

Kategorien

Gefragt:

am 9 Apr. 2018

Beantwortet:

am 16 Apr. 2018

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by