Clear Filters
Clear Filters

Extracting a value from one column to its corresponding column?

2 views (last 30 days)
Hi, I have a matrix (say 7 x 2). first column contains id and second column contains scores. I want to write a code to extract id from first column which is corresponding to minimum score in second column?
M = 1 363.026
11 330.302
24 289.07
55 240.3120
59 188.209
79 162.937
87 108.104
I know 87 has lowest score. But how to write effective code so that for larger matrix it should fetch id corresponding to lowest score? Thanks

Accepted Answer

KSSV
KSSV on 15 Dec 2016
Edited: KSSV on 15 Dec 2016
[val,idx] = min(M(:,2)) ; % get minimum value and position from scores
id = M(idx,1) ; % get the id of the minimum score

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!