MATLAB Answers

0

How do I sort the max values from a matrix ?

Asked by Pierre Lonfat on 23 May 2017
Latest activity Edited by KSSV
on 23 May 2017
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

  0 Comments

Sign in to comment.

Tags

2 Answers

Answer by Guillaume
on 23 May 2017
Edited by Guillaume
on 23 May 2017
 Accepted Answer

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

  0 Comments

Sign in to comment.


Answer by KSSV
on 23 May 2017
Edited by KSSV
on 23 May 2017

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

  0 Comments

Sign in to comment.