MATLAB: How to sort the max values from a matrix

sort

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

Best Answer

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

Or:

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

Related Solutions

MATLAB: How to deletes rows after a certain row

Try this:

Data = randi(99, 100, 1);                               % Create Data
Sorted_Data = sort(Data, 'descend');                    % Sort Descending
Keep_Data = Sorted_Data(1:50);                          % Data To Be Kept

MATLAB: Sort(x) doesn’t work properly.

How do you know it is not sorted. The following code shows that it is indeed sorted

daily_logreturns_sorted = sort(daily_logreturns);
tf = all(diff(daily_logreturns_sorted)>=0)

Result

>> tf
tf =
  logical
   1

Best Answer

Related Solutions

MATLAB: How to deletes rows after a certain row

MATLAB: Sort(x) doesn’t work properly.

Related Question