MATLAB: I have time series data of 1 year each day 2880 values row wise so a matrix of 365X2880. I want to do monthly average. January 31 days average one file of one month, so that I can finally get 12 files each of monthly average.

Question

I have time series data of 1 year each day 2880 values row wise so a matrix of 365X2880.

I want to do monthly average. January 31 days average one file of one month, so that I can finally get 12 files each of monthly average.

I think should be considered, days in each month are not same. I have 2015 data so it is not a leap year, Therefore february contain 28 days.

Plese help me to come out of it

Answer 1

A - you're array 365 x 2880, in example per 2015 year.

t = (datetime(2015,1,1):datetime(2015,12,31))';
TT = array2timetable(A,'RowTimes',t);
T_out = retime(TT,'monthly','mean');