how to fill matrix in a specific way

Question

lucksBi 2017-3-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/330140-how-to-fill-matrix-in-a-specific-way

评论： lucksBi 2017-3-16

Hi I have a matrix like this,

I want to take unique values from column 1 and 2 and sort them. Then create another matrix with rows and columns of sorted matrix and fill it with values in 3rd column of original matrix. like shown in attached image:

Thanks in advance

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

请先登录，再进行评论。

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

Answer 1

KSSV 2017-3-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/330140-how-to-fill-matrix-in-a-specific-way#answer_258960

在 MATLAB Online 中打开

A = [11 44 1; 11 33 -1; 22 11 1; 22 44 1; 22 33 1;33 44 1; 33 22 -1; 44 11 1 ;
    44 22 -1; 44 33 1] ;
c1 = A(:,1) ; c2 = A(:,2) ;
c1 = unique(c1) ;
c2 = unique(c2) ;
iwant = zeros(length(c1)+1,length(c2)+1) ;
iwant(2:end,1) = c1 ;
iwant(1,2:end) = c2 ;
for i = 2:size(iwant,1)
    for j = 2:size(iwant,2)
        [val,idx] = ismember([iwant(1,i) iwant(j,1)],A(:,1:2),'rows')  ;
        if idx~=0
            iwant(i,j) = A(idx,3) ;
        end
    end
end