How can I sort a matrix according to column IDs and identify same combinations?

Question

Iro 2013-5-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/74400-how-can-i-sort-a-matrix-according-to-column-ids-and-identify-same-combinations

Hi,

I edit the question: I have matrix M with six columns and n rows:

M = [HomeID, WorkID, SchoolID, ShopID, timeS, timeP];
for example (lets say it is already sorted):
M = [101, 201, 301, 401, 5.46, 7.83;
    101, 201, 301, 401, 3.63, 4.52;
    101, 201, 301, 401, 2.785, 2.99;
    102, 205, 301, 401, 3.53, 8.5;
    102, 205, 301, 402, 3.48, 8.9];

I want to make it in the form of:

 M2 = [101, 201, 301, 401, 3.958, 5.113;
       102, 205, 301, 401, 3.53, 8.5;
       102, 205, 301, 402, 3.48, 8.9];

I want to make calculation for each unique pair of SchoolID-WorkID combination within each unique pair of HomeID-WorkID combination and produce a matrix which will have no multiple Home-Work-School-Shop registers but the unique ones with the average values instead [M2(1,4)=(M(1,4)+M(2,4)+M(3,4))/3].

Thanks,

Iro

6 个评论
显示 4更早的评论隐藏 4更早的评论

Zhang lu 2013-5-3

102, 201, 301, 401, 3.53, 8.5; ？ what is it from?

Iro 2013-5-3

Hi Zhang lu..Does it really matter? It is just random numbers I used to illustrate my question. :)

请先登录，再进行评论。

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

Answer 1

Jonathan Sullivan 2013-5-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/74400-how-can-i-sort-a-matrix-according-to-column-ids-and-identify-same-combinations#answer_84294

编辑：Jonathan Sullivan 2013-5-3

在 MATLAB Online 中打开

Accumarray would come in handy here. It's a rather useful function, but might take a little bit of reading to understand it completely. Basically it takes in a list of coordinates (subscripts) and the values associated with them. It then does an operation on all those values that have the same subscripts, and outputs the resulting value as an entry in a matrix. In this case, you want to take the mean of those values that have the same HomeID WorkID SchoolID and ShopID.

Here's how we do it:

% Get the unique combinations, and the indexes
[HomeSchoolWorkShop_ID,~,y_ind] = unique(M(:,1:4),'rows');
x_ind = 1:size(M,2)-4;
% Make a list of the indexes and values
[X_Ind,Y_Ind] = meshgrid(x_ind,y_ind);
Inds = [Y_Ind(:) X_Ind(:)];
vals = reshape(M(:,5:end),[],1);
% Take the average
M2 = [HomeSchoolWorkShop_ID accumarray(Inds,vals,[],@mean)]

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

Iro 2013-5-3

编辑：Iro 2013-5-3

Hi Jonathan, thanks for your answer. I did it and works! *Accumarray *looks good for my case if it can accommodate also more complex calculations, I will take a careful look. Cheers! /Iro

请先登录，再进行评论。