0 个投票

Hi
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!

请先登录，再回答此问题。

 采纳的回答

Andrei Bobrov
Andrei Bobrov 2017-3-24

1 个投票

[~,~,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);

4 个评论
显示 2更早的评论 隐藏 2更早的评论

davit petraasya
davit petraasya 2017-3-24
Thank you Andrei! It worked.
davit petraasya
davit petraasya 2017-3-29
编辑：davit petraasya 2017-3-29
Hi Andrei, can you do me one more favor,please? Now I have values corresponding to months. How I may stack monthly values?(Attached file)
Thank you!
Andrei Bobrov
Andrei Bobrov 2017-3-29
[d,~,c] = xlsread('stack_montlyvalues.xlsx');
[~,m] = datevec(c(:,1),'yyyy-mm-ddTHH:MM:SS.FFFZ');
[a,~,ii] = unique(m);
out = [a,accumarray(ii,d)];
davit petraasya
davit petraasya 2017-4-3
Thanks a lot for your help again Andrei. Code is working!

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by