For loop through cell arrays

91 次查看（过去 30 天）

显示更早的评论

Ali Yilmaz 2020-6-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/553441-for-loop-through-cell-arrays

评论： Ali Yilmaz 2020-6-25

采纳的回答： Adam Danz

在 MATLAB Online 中打开

I have a 1×4 cell array of

{60×4 double} {60×4 double} {60×4 double} {60×4 double}

and I need to;

-find the values at the 3rd column at the rows have "20" at the first column in each cell

-then eliminate zeros if there is any

-then take average

As an illustration

          10         NaN           0         NaN                     20         NaN         623           1         
          10         NaN           0         NaN                     20         NaN           0         NaN
          20         NaN         310           1                     10         NaN          38           1
          20         NaN           0         NaN                     10         NaN           0         NaN
          20         NaN        1445           1                     10         NaN           0         NaN

the first cell should give the average of 310 and 1445, whereas the second cell should give 623.

I am thinking of a for loop but I couldnt make it work. Thanks in advance!

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

Ali Yilmaz 2020-6-23

Hi Adam,

Honestly I deleted my version as it was not even close to what I need. I'll be glad if you can share your version.

Thanks and regards

Adam Danz 2020-6-25

See answer below.

请先登录，再进行评论。

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

采纳的回答

Adam Danz 2020-6-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/553441-for-loop-through-cell-arrays#answer_456553

编辑：Adam Danz 2020-6-25

在 MATLAB Online 中打开

If you want to do this in a loop, there are 4 steps I've outlined below.

"c" is the 1x4 cell array.

column3Means = nan(size(c)); 
for i = 1:numel(c)
    % Find rows where column 1 equals 20
    index1 = c{i}(:,1) == 20; 
    
    % Find rows where column 3 is not 0
    index2 = c{i}(:,3) ~= 0; 
    
    % Combine those indices
    idx = index1 & index2; 
    
    % Use the combined index to compute the mean
    column3Means(i) = mean(c{i}(idx,3),'omitnan');
end