How to calculate the mean from cell when each cell is a different double.

1 次查看（过去 30 天）

mohsen moslemin 2016-8-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300426-how-to-calculate-the-mean-from-cell-when-each-cell-is-a-different-double

评论： mohsen moslemin 2016-8-22

Hi Im reading excel files and storing them into data{k} so my data is 1x34 cell and each cell is a double, with variable column number and fixed row 13, now i want to calculate mean of 34 files for column and row 1 and do the same for the rest.I tried cell2mat but this doesnt work as i have different values for columns.

     folder='E:\Engine image\E100 cycles\All Excel Files';
filetype='*.xlsx';  
f=fullfile(folder,filetype);
d=dir(f);
for k=1:numel(d);
  data{k}=xlsread(fullfile(folder,d(k).name));
end

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

请先登录，再进行评论。

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

采纳的回答

Andrei Bobrov 2016-8-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300426-how-to-calculate-the-mean-from-cell-when-each-cell-is-a-different-double#answer_232421

编辑：Andrei Bobrov 2016-8-22

在 MATLAB Online 中打开

EDIT

m = numel(data);
[ii,~]= cellfun(@size,data);
a = nan(max(ii),size(data{1},2),m);
for jj = 1:m
    a(1:ii(jj),:,jj) = data{jj};
end
out = nanmean(a,3);

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

mohsen moslemin 2016-8-22

i think this makes it easier to explain i have 34 excel like this what i want is to read them all, what ive done so far now i want to average each value from 34 data, eventually i should have same matrix but each value is the average of 34 values.

请先登录，再进行评论。

更多回答（1 个）

Azzi Abdelmalek 2016-8-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300426-how-to-calculate-the-mean-from-cell-when-each-cell-is-a-different-double#answer_232419

在 MATLAB Online 中打开

cellfun(@(x) mean(x,2),data,'un',0)

5 个评论
显示 3更早的评论隐藏 3更早的评论

Azzi Abdelmalek 2016-8-22

编辑：Azzi Abdelmalek 2016-8-22

This is not clear, to make your problem clear, you can post a short example, and also post the expected result, you haven't specified clearly what mean we have to calculate. You said also, that your matrices are not the same sizes

mohsen moslemin 2016-8-22