Matrix manipulation depending on maximum and minimum values of existing matrix.

Question

prashanth 2014-4-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/127053-matrix-manipulation-depending-on-maximum-and-minimum-values-of-existing-matrix

评论： prashanth 2014-4-25

This first matrix table1 contains normalized values for 5 names.I need to perform some operations on this matrix and I have to obtain second matrix as shown in table2.

Diagonal elements of table2 should obtained by giving rank(ordinal value) to each value.That means highest element is given 5th rank and next 4th 3rd and so on.

Remaining elements of table obtained by giving rank to each value starting from 4 because only 4 elements remaining. Because already we are given rank to diagonal elements.Zero should be kept as it is.Suppose take table1 as A matrix and table2 as B matrix.

OPERATION1:For diagonal elements

       B(1,1)=5(first largest element)
       B(2,2)=1(5th largest element)
       B(3,3)=4(4th largest element)
       B(4,4)=2(2nd largest element)
       B(5,5)=3(3rd largest element)
OPERATION2:For remaining elements
          B(1,2)=3(2nd largest element)
          B(1,3)=4(1st  largest element)
          B(1,4)=1(4th largest element)
          B(1,5)=2(3rd largest element)
And so on..
       Table1:
               BASAVARAJ MANOJ  NATESH  VIJAY  GOWDA
          
BASAVARAJ  1.0000  0.2727  0.3182  0.0455  0.2727
MANOJ          0.2727  0.2727    0    0    0
NATESH          0.3182    0  0.4545  0.1818    0
VIJAY          0.0455    0  0.1818  0.2727  0.0909
GOWDA          0.2727    0    0  0.0909  0.3636
       Table2:
                        BASAVARAJ    MANOJ   NATESH  VIJAY  GOWDA
         BASAVARAJ      5         3  4  1  2
         MANOJ              4         1  0  0  0
         NATESH              4         0  4  3  0
         VIJAY              2         0  4  2  3
         GOWDA              4         0  0  3  3

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2014-4-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/127053-matrix-manipulation-depending-on-maximum-and-minimum-values-of-existing-matrix#answer_134447

在 MATLAB Online 中打开

I'd think you'd extract each column, sort to get the sorting indexes, then put those back into the table. Something like (untested);

% Extract column 1
column1 = table1.BASAVARAJ;
% Sort column1
[sortedValue, sortIndexes] = sort(column1);
% Stuff back in
table1.BASAVARAJ = sortIndexes;

Repeat for the other columns.

2 个评论
显示无隐藏无

prashanth 2014-4-25

First i have to sort diagonal elements.Next i have to sort remaining.One problem is zero should be remain same. It should not be altered.How it can be done?

prashanth 2014-4-25