MATLAB: How to find “maximum” value in a table

cellscolumnsmaximumrowstable

How to find "maximum" value in a table and to extract the other data's based on maximum value (i.e maximum value row):
I have a table with 6 columns as shown below
Calcul = table;
Calcul.Element = cell2mat(raw(:, 1));
Calcul.Tau = cell2mat(raw(:, 2));
Calcul.Pressure = cell2mat(raw(:, 3));
Calcul.VMStress = cell2mat(raw(:, 4));
Calcul.SPmax = cell2mat(raw(:, 5));
Calcul.SPmin = cell2mat(raw(:, 6));
I need to find a maximum value/cell of a particular column and to extract all the data from these 6 columns (i.e row of a particular cell) as attached in the image.
Please help me
Thanks in advance

Best Answer

Can accomplish this easier with indexing
>> T = readtable('test1.txt');
>> [~,maxidx] = max(T.SPmin);
>> T(maxidx,:)
ans =
1×6 table
    Element     Tau      Pressure    VMStress    SPmax     SPmin 
    _______    ______    ________    ________    ______    ______
     54281     2.5304    -3.6719      4.479      6.5101    1.4493
Related Question