Select only January and April months among 30 years monthly data (how to filter?)

1 次查看（过去 30 天）

BN 2020-3-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513680-select-only-january-and-april-months-among-30-years-monthly-data-how-to-filter

评论： BN 2020-3-29

CELL.mat

Hey all,

I have a cell (1 x 92) which includes 92 tables . In each table I have a column named dates. I want to filter the whole table based on January and April. I wish if it is possible have the value of January and April as 2 column after all existing column in each table (cell array), for example:

Thank you so much

6 个评论
显示 4更早的评论隐藏 4更早的评论

Walter Roberson 2020-3-29

在 MATLAB Online 中打开

jan_rrr24 and april_rrr24 are already the extracted rrr24 values for the respective months.

You cannot construct a table that contains both jan_rrr24 and april_rrr24 entries because there are a different number of days in January (31) than in April (30) so you will not have the same number of rows for the two.

nCELL = numel(CELL);
newCELL = cell(nCELL, 2);
for i=1:nCELL
    date_month = month(CELL{i}.dates);
    jan_mask = date_month == 1;
    april_mask = date_month == 4;
    jan_rrr24 = CELL{i}.rrr24(jan_mask);
    april_rrr24 = CELL{i}.rrr24(april_mask);
    newCELL{i,1} = jan_rrr24;
    newCELL{i,2} = april_rrr24;
end