how to stack monthly(hist)

2 visualizaciones (últimos 30 días)
davit petraasya
davit petraasya el 24 de Mzo. de 2017
Comentada: davit petraasya el 3 de Abr. de 2017
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!

Iniciar sesión para responder a esta pregunta.

Respuesta aceptada

Andrei Bobrov
Andrei Bobrov el 24 de Mzo. de 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);
  4 comentarios
Mostrar 2 comentarios más antiguos
Andrei Bobrov
Andrei Bobrov el 29 de Mzo. de 2017
[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 el 3 de Abr. de 2017
Thanks a lot for your help again Andrei. Code is working!

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Dynamic System Models en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by