how to stack monthly(hist)

1 view (last 30 days)
I have time series. I want to stack monthly(hist). I need to count how many times my time series repeated in every month for given long period and stack each month results. January+January, February+February, March+March..... Such as January would be repeated 250, February 300, March 280.......
(Please see attached excel file).
Thanks a lot!

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 24 Mar 2017
[~,~,c] = xlsread('stack_monthly.xlsx');
[y,m] = datevec(c,'yyyy-mm-ddTHH:MM:SS.FFFZ');
a = unique([y,m],'rows');
out = accumarray(a(:,2),1);
davit petraasya
davit petraasya on 3 Apr 2017
Thanks a lot for your help again Andrei. Code is working!

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!