Calculating average of cell arrays

Question

BN 2020-4-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/518540-calculating-average-of-cell-arrays

评论： BN 2020-4-17

SAMPLE.mat

Hello all,

I have a 1 x 3 cell which represents monthly data from 1989 to 2016 for 3 models (each cell arrays is for one model). I want to calculate average value of the precip column of these 3 models for monthly 1989 to 2016. So the output will be a 1 x 1 cell which contains the average value of precip in all models from 1989 to 2016 (monthly). It is so hard for me and I tried some codes but they are not accomplished well.

This is a sample data sets and I have more than 100 cell arrays which some of them ends in 2018 instead of 2016.

Thank you so much.

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

请先登录，再进行评论。

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

Answer 1

dpb 2020-4-16

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/518540-calculating-average-of-cell-arrays#answer_426501

编辑：dpb 2020-4-17

在 MATLAB Online 中打开

mnTemp=cellfun(@(t) mean(t.precip),SAMPLE);

with the sample dataset:

 >> cellfun(@(t) mean(t.precip),SAMPLE)
ans =
   27.8985   62.4198   43.8376
>>

Don't provide any details on how these data/models were created but would be much easier to combine the various data into one table or timetable with the column variables representing the models.

ADDENDUM:

It's still the wrong way to store the data, but...

mnTemp=mean(cell2mat(cellfun(@(t) (t.precip),SAMPLE,'UniformOutput',false)),2);