monts in year sequence, string, matrix
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Nikola Ostojic
am 16 Jan. 2021
Kommentiert: Nikola Ostojic
am 16 Jan. 2021
I have a series of 365 days. I need to divide the elements of the array into months with 31, 28, 31, 30 .. days and add the values for the months.
The result should be a series of 12 months with aggregated values for each month.
can i have a reshape function?
0 Kommentare
Akzeptierte Antwort
Walter Roberson
am 16 Jan. 2021
Convert to a timeseries() object and use retime()
Or:
Data = rand(365,1);
Data_timestamp = datetime(2021, 1, 1:365).'; %use non-leap year !
month_totals = accumarray(month(Data_timestamp), Data)
Weitere Antworten (1)
dpb
am 16 Jan. 2021
Add the date to a timetable and retime with aggregation--
tt=timetable(datetime(yr,1,1:365).',data); % make timetable of days and your data
ttAgg=retime(tt,'monthly','sum');
Siehe auch
Kategorien
Mehr zu Timetables 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!