I want annual data from monthly data (sum of every 12 months)

Question

BN 2020-3-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513910-i-want-annual-data-from-monthly-data-sum-of-every-12-months

编辑： Peng Li 2020-3-30

CELL.mat

Hey all,

I have a 1 x3 cell which contains 3 tables (360x3). In each table, there is a "dates" column (MM/DD/YYYY) and precipitation value (rrr24) column. The dates are for 30 years, monthly. Please help me to have another 1 x3 cell (newcell) which contains 30x3 tables with the amount of precipitation for each year instead of the month. I would like to use the sum function to convert monthly precipitation to annual.

I attached my cell.

Thank you so much.

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

请先登录，再进行评论。

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

Answer 1

Peng Li 2020-3-30

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513910-i-want-annual-data-from-monthly-data-sum-of-every-12-months#answer_422919

在 MATLAB Online 中打开

Hi, you again lol and me again

I thought it would be easier for you to solve this with my previous answer regarding the season stuff.

newCell = cellfun(@cusFun, CELL, 'UniformOutput', 0);
function cusTbl = cusFun(tbl)
tbl.year = year(tbl.dates);
[grp, cusTbl]    = findgroups(tbl(:, 'year'));
cusTbl.sum_rrr24 = splitapply(@sum, tbl.rrr24, grp);
cusTbl.grid_name = splitapply(@(x) x(1), tbl.(1), grp);
end