Skip to main content
Y
YA_1096379814-Alexandrite
14-Alexandrite
May 7, 2024
Solved

minimum value in each column in several matrices

  • May 7, 2024
  • 1 reply
  • 2510 views

I hope you are doing well. 

I need to take this sheet a step further.  Now after we get 24 matrics . I need to find the minimum value in each column in each matrix. 

For example: matrix Linters 23 will have a matrix of the minimum values of each colunm . I tried to do it as follows but couldn't get what i want since it gives me the minimum in the whole matrix . I need  the minimum in each column in each matrix.

Like in excel you select the colunum and find the minimum in that column. Sorry for bothering you a lot. But I genuinely appreciate your help

YA_10963798_0-1715066551554.png

 

 

Best answer by Werner_E

You could use a utility function which take a matrix as its input and returns a row vector with the minimum values of each column

Werner_E_0-1715080818034.png

You may apply this function to individual matrices of L.inters

Werner_E_1-1715080850819.png

Werner_E_2-1715080861472.png

or create a table with all 24 rows

Werner_E_3-1715080939841.png

 

You may create the very same table in on go, too

Werner_E_4-1715081107523.png

 

 

 

1 reply

W
Werner_E25-Diamond IAnswer
25-Diamond I
May 7, 2024

You could use a utility function which take a matrix as its input and returns a row vector with the minimum values of each column

Werner_E_0-1715080818034.png

You may apply this function to individual matrices of L.inters

Werner_E_1-1715080850819.png

Werner_E_2-1715080861472.png

or create a table with all 24 rows

Werner_E_3-1715080939841.png

 

You may create the very same table in on go, too

Werner_E_4-1715081107523.png

 

 

 

    Y
    YA_1096379814-AlexandriteAuthor
    14-Alexandrite
    May 30, 2024

    Why I'm getting zeros here ?

    Actually zeros mean the function doesn't apply in Linteres ...I want to get the minimum value except for zero. the nearest minimum value

    I should get the minimum value of each column in each matrix 

    YA_10963798_0-1717056933251.png

     

    ttokoro
    21-Topaz I
    ttokoro21-Topaz I
    21-Topaz I
    May 30, 2024

     

    Identity of L intes[1 are all 0. So, min are all 0. If max you get below.

    image.png

    image.png

    If you want mimimum but not 0, select the next data by sorting. 0 data should appear each only one time is assumed.

    ttokoro_0-1717067901431.png

     

    image.png

    t.t.
      Terms & ConditionsAccessibility statement