How to extract monthly data in a matrix
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Stefania Avvedimento
el 14 de Feb. de 2022
Respondida: Arif Hoq
el 14 de Feb. de 2022
Dear all,
I have a matrix of monthly precipitation values for a period of 30 years, from 1971 to 2000 (see Fig. 1 attached).
I would like to extract for each month the values of precipitation of all the years considered, as shown in Fig. 2 (I did it manually). Since I have to repeat this procedure for several climate models, could you please give me any suggestion on how to automatize the extraction?
BR,
Stefania
0 comentarios
Respuesta aceptada
Arif Hoq
el 14 de Feb. de 2022
As you did not attach any data, i took the random data
A=readtable('Data.xlsx');
Data=table2array(A(:,2));
Year=(1971:2000)';
N=length(Data);
C=cell(N/30,1);
for i=1:12:N
C{i}=Data(i:i+11);
end
Matrix=[C{:}]';
Output=[Year Matrix]
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Climate Science and Analysis en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!