Return the table column # containing the maximum value in a row

Bryan Wilson

2017 4 22

1 个回答

1 次查看（30 天）

0 个投票

In my table, T, columns 14 through 27 contain numeric data. I want to find the maximum value in each row and then return the associated column # or column title.

I can get the value with:

for i=1:size(T)
   maximum = max(T{i,14:27});
end

But I'm struggling to get the associated column # or title.

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

请先登录，再进行评论。

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

Follow Question

回答（1 个）

Peter Perkins 2017-4-25

在 MATLAB Online 中打开

1 个投票

I think you want something like this:

[maxVals,maxLocs] = max(T{:,14:27},[],2)

In other words, for the contents of the 14th-27th variables in T, find the maximum value and the variable in which it occurred. If you want the var names, follow up with this:

maxVarNames = T.Properties.VariableNames(maxLocs)