How do I sort the max values from a matrix ?

Hello everyone !

In the following 577X2 matrix I have tickers of stocks in the first column and the number of occurence in the second one.

How would I keep the 80 first stocks (tickers) that occurred the most ?

Many thanks in advance !

Pierre

Answer 1

[Guillaume]

[~, order] = sort(Occurences.Momentum(:, 2), 'descend');
top80 = Occurences.Momentum(order(1:80), :)

Or:

sortedData = sortrows(Occurences.Momentum, 2, 'descend');
top80 = sortedData(1:80, :)

Answer 2

[KSSV]

Let data be you 577X2 data.

[val,idx] = sort(data(:,2),'descend') ;   % sort the second column in descending order 
iwant = data(idx(1:80),:) ; % pick first 80 most occurring stocks