Finding out the average values per day

25 Ansichten (letzte 30 Tage)
Mark Rodger
Mark Rodger am 9 Apr. 2018
Beantwortet: Akira Agata am 16 Apr. 2018
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
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

Mehr zu Tables finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by