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

How do I average rows which contain the same first to elements?

1 次查看（过去 30 天）
Glenn Roumen
Glenn Roumen 2013-6-10
I'm stuck on this problem for a while. I want to obtain a matrix which is averaged for the rows which contain the same first two elements. I don't want to clear the rows which are not equal for the first two elements. When I have a matrix A:
A=[1 1 1 1 1
1 2 3 4 5
1 2 4 4 4
1 2 3 3 3
2 2 2 2 2
2 2 3 3 3]
I want the outcome to be:
A=[1 1 1 1 1
1 2 3.33 3.67 4
2 2 2.5 2.5 2.5]
I hope someone could help me on this.

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

采纳的回答

Ahmed
Ahmed 2013-6-10
This solution is not very elegant, but should work. There is room for improvement, though.
uA = unique(A(:,1:2),'rows');
A = [uA cell2mat(cellfun(@(x)...
mean(A(all(bsxfun(@eq,A(:,1:2),x),2),3:end),1), ...
num2cell(uA,2),...
'UniformOutput',false)) ]

更多回答（1 个）

Andrei Bobrov
Andrei Bobrov 2013-6-10
编辑：Andrei Bobrov 2013-6-10
[~,~,c] = unique(A(:,1:2),'rows');
out = accumarray([repmat(c,size(A,2),1) kron((1:size(A,2))',...
ones(size(A,1),1))],A(:),[],@mean);
or
[c c c] = unique(A(:,1:2),'rows');
[ii,jj] = ndgrid(c,1:size(A,2));
out = accumarray([ii(:) jj(:)],A(:),[],@mean);

类别

在 Help Center 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by