How can one "summarize a matrix with the first four columns"?

Question

alpedhuez 2020-7-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/572464-how-can-one-summarize-a-matrix-with-the-first-four-columns

评论： Jon 2020-8-7

First, I have a matrix like

Second, what I would like to do is to summarize the matrix with the first four columns. That is, here, I want to take an average of the entries of the fifth item for the rows that has the same first four columns. In this example, it will be

Please advise.

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

请先登录，再进行评论。

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

Answer 1

Jon 2020-7-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/572464-how-can-one-summarize-a-matrix-with-the-first-four-columns#answer_472669

编辑：Jon 2020-7-29

在 MATLAB Online 中打开

Here is one way to do it. There might be some clever way to fully vectorize (eliminate the loop) this, but this will work if performance on huge arrays isn't an issue

% define your original matrix 
A = [1 2 3 4 1.1;1 2 3 4 3; 1 2 3 5 4; 2 3 4 1 6]
% find rows with unique first four elements
 [C,~,ic] = unique(A(:,1:4),'rows')
 
 % summarize by finding average of elements in fifth column over rows with
 % same first four columns
 
 for k = 1:length(ia)
     % use logical indexing to find rows with unique first four elements
     C(k,5) = mean(A(ic==k,5))
 end

2 个评论
显示无隐藏无

alpedhuez 2020-7-29

Thank you. There might be "accumarray" solution in the third part that I would like to understand.

Jon 2020-8-7

在 MATLAB Online 中打开

Good idea using accumarray. I didn't know that command. Definitely looks like it has some possibilities.

C(:,5) = accumarray(ic,A(:,5))./accumarray(ic,1)

instead of the for loop works for this case. I would have to think about it more to know if there are any edge cases where this would fail, but I think it maybe a nice way to do it.

请先登录，再进行评论。