finding the 10 lowest values

19 views (last 30 days)
Adam
Adam on 13 Oct 2011
Commented: Adam on 23 Feb 2017
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

Artik Crazy
Artik Crazy on 13 Oct 2011
  • 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)

the cyclist
the cyclist on 13 Oct 2011
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
Adam
Adam on 23 Feb 2017
the cyclist gave an answer that also returns indices. You can just feed these directly into your array.

Sign in to comment.

Categories

Find more on Shifting and Sorting Matrices in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!