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

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

Answer 1

[Image Analyst]

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.

[prashanth]

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]

Please help me iam doing my last module of my project.My deadline of my project is very nearer.Please someone help me.