MATLAB: Take averages of obvervations for each month

MATLAB

suppose I have a table S
date             income
----------------------------
1/1/2020     100
1/2/2020     20
I want to create a table T of mean of income at each month like
month            income average
----------------------------
1/2020     50
2/2020     20
So is it that I first create 
T.yyyyMM=datetime(S.date, 'InputFormat','MM/dd/yyyy', 'Format','yyyyMM');
then use
T.accumarray(T.yyyyMM,S.income,[],@mean)
Does it make sense?

Best Answer

Try this instead
retime(T,'monthly','mean')
where T is a timetable
example
t = (datetime(2020,1,1):days(1):datetime(2021,1,1))';
income = 10+rand(numel(t),1).*4;
T = timetable(t,income)
T_Monthly = retime(T,'monthly','mean')
Related Question