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

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.

Answer 1

[Peng Li]

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

[BN]

Dear Peng Li

Thank you so much. I never forget your precious help at this moment that my university is closed and quarantine restricts my contact ways.

Be healthy

Best regards?

[Peng Li]

Thanks Behzad Navidi. Stay safe!

I'm working from home too because of the virus.