How to find "maximum" value in a table

Question

Lal 2018-6-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/404148-how-to-find-maximum-value-in-a-table

评论： Peter Perkins 2018-6-7

采纳的回答： Razvan Carbunescu

在 MATLAB Online 中打开

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

4 个评论
显示 2更早的评论隐藏 2更早的评论

Lal 2018-6-5

编辑：Lal 2018-6-5

在 MATLAB Online 中打开

VM_max = max(Calcul.VMStress);
VM_max

This is giving maximum of 4th column. How do I extract the row (VM_max) ?

Thanks in advance

Peter Perkins 2018-6-7

Stephen's comment was just that you have six lines to create six table variables, and because each of those six references a column in the same cell array, you could replace all those with one call to cell2table.

请先登录，再进行评论。

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

Answer 1

Razvan Carbunescu 2018-6-5

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/404148-how-to-find-maximum-value-in-a-table#answer_323321

在 MATLAB Online 中打开

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

2 个评论
显示无隐藏无

Lal 2018-6-5

编辑：Lal 2018-6-5

Thank you for your answer. Could you please explain me how the code is working?

Thank you

Razvan Carbunescu 2018-6-5

The second line computes the max of T.SPMin and stores the position where that max is found in maxidx. Then via table indexing on the 3rd line can find the result.

请先登录，再进行评论。