清空筛选条件
清空筛选条件

Manipolation of cell array and

2 次查看（过去 30 天）
Maurizio
Maurizio 2011-12-20
I have three cell array as per below and I would like to create a for loop that read directly one per time the three array and do the sum of the numeric value (columns 3 and for) for each groups. Is it possible?
Groups{1}
Groups{2}
Groups{3}
ans =
'a' 'b' [1] [2] [3]
'a' 'b' [3] [4] [5]
ans =
'b' 'z' [3] [4] [5]
'b' 'z' [4] [5] [6]
ans =
'r' 't' [5] [6] [7]
'r' 't' [6] [7] [8]

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-12-20
Do you want to sum the 3rd and 4th column all together or separately? Anyway, it should be similar to this.
Out=zeros(size(Groups));
for k=1:numel(Groups)
Out(k)=sum([Groups{k}{:,3}]);
end
  4 个评论
显示 2更早的评论
Maurizio
Maurizio 2011-12-20
is it possible to have all the output sum in just one cell instead of k cell struct?
Fangjun Jiang
Fangjun Jiang 2011-12-20
The variable Output in the above code is not a cell. It is a double array. If you want to put it in a cell, just use {Output}

请先登录，再进行评论。

更多回答（1 个）

Titus Edelhofer
Titus Edelhofer 2011-12-20
Hi,
yes, should be not too difficult, as long as you know where the numeric values are:
values = zeros(2,3);
for i=1:length(Groups)
values = values + cell2mat(Groups{i}(:, 3:5));
end
Titus
  1 个评论
Maurizio
Maurizio 2011-12-20
An if I would like to have the average of colums 4 of each group.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by