Finding maximum value and returning variable name of the column

Question

Karel Starý 2022-3-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1672179-finding-maximum-value-and-returning-variable-name-of-the-column

回答： Cris LaPierre 2022-3-15

采纳的回答： Davide Masiello

在 MATLAB Online 中打开

Hello all!

Data:

A = [1;2;3;4];
B = [5;4;1;2];
C = [2;3;2;5];
T=table(A,B,C);

I would like to have a function that would check each row for the largest number and return the name of the collum where the max value was found. In this case, it should return: B,B,A,C

The table is just an example, I don't mind using cell arrays, tables or any other way how to work with the data.

Additional points: How to make sure that the function would return the character closest to A in case the largest numbers would occur multiple times in the same row?

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

请先登录，再进行评论。

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

Answer 1

Davide Masiello 2022-3-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1672179-finding-maximum-value-and-returning-variable-name-of-the-column#answer_918149

编辑：Davide Masiello 2022-3-15

在 MATLAB Online 中打开

clear,clc
A = [1;2;3;4];
B = [5;4;1;2];
C = [2;3;2;5];
T=table(A,B,C);
[maxval,idx] = max(table2array(T),[],2);
T.Properties.VariableNames(idx)
ans = 1×4 cell array
    {'B'}    {'B'}    {'A'}    {'C'}

Regarding the additional point question, I think the max function will do that by default (i.e. it will return the first max value it finds on a specific row). Check this for instance:

clear,clc
A = [1;4;3;4];
B = [5;4;1;2];
C = [2;3;2;5];
T=table(A,B,C);
[maxval,idx] = max(table2array(T),[],2);
T.Properties.VariableNames(idx)
ans = 1×4 cell array
    {'B'}    {'A'}    {'A'}    {'C'}