finding the 10 lowest values

I have a matrix with a lot of data, and i want to find the 10 lowest values of a specific collum.
Does anybody know how to do that?
i was thinking about using the function min() but it does not allow me to select a specific collum, or finding more than the one value which is the lowest.

 Accepted Answer

  • Let's say you have a matrix of 10x10:
x=rand (10,10);
  • Sort it by the columns in ascending order:
y=sort (x,1, 'ascend')
*Now take the 5 first rows - these are the lowest values in every column:
z=y(1:5, :)

More Answers (2)

First 10 values of "sorted_x" is what you want.
A = rand(100,10);
columnToSort = 7;
[sorted_x, index] = sort(A(:,columnToSort),'ascend');
Marc
Marc on 23 Feb 2017
But if I want the indexes of these 10 values? Should I sort to find the values and then "find" these values in the matrix?
Is there a more elegant way?

1 Comment

the cyclist gave an answer that also returns indices. You can just feed these directly into your array.

Sign in to comment.

Categories

Asked:

on 13 Oct 2011

Commented:

on 23 Feb 2017

Community Treasure Hunt

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

Start Hunting!