How to calculate monthly data from daily rainfall data in a time-seris 3-dimensional matrix?

Question

ehsan 2019-3-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/450329-how-to-calculate-monthly-data-from-daily-rainfall-data-in-a-time-seris-3-dimensional-matrix

回答： Walter Roberson 2019-3-16

I have a matrix with the size of 17 x 22 x 332. 17 stands for Latitude, 22 Longitude and 322 is days starts from Apr 1st, 2014 to Feb. 26st, 2015. At the end I should have a matrix with the size of 17 x 22 x 11.

I have tried different ways using reshape, permute etc. but I couldn't find the right way.

Since in the fiture I might use data from longer time-period (for example 15 years) I would like to derive aggregated rainfall for each month using datetime or timetable function, if possible.

I would appreciate any help.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2019-3-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/450329-how-to-calculate-monthly-data-from-daily-rainfall-data-in-a-time-seris-3-dimensional-matrix#answer_365706

mat2cell() to break the 17 x 22 x 332 up into cell arrays 17 x 22 x number_of_days_in_month . Then you can cellfun(@(M) sum(M,3), the_cell_array, 'uniform', 0) to get a 17 x 22 x 11 cell after which you cell2mat() to get 17 x 22 x 11 array.