How do I sort the max values from a matrix ?

2 次查看（过去 30 天）
Pierre Lonfat
Pierre Lonfat 2017-5-23
编辑： KSSV 2017-5-23
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

请先登录，再回答此问题。

采纳的回答

Guillaume
Guillaume 2017-5-23
编辑：Guillaume 2017-5-23
[~, order] = sort(Occurences.Momentum(:, 2), 'descend');
top80 = Occurences.Momentum(order(1:80), :)
Or:
sortedData = sortrows(Occurences.Momentum, 2, 'descend');
top80 = sortedData(1:80, :)

更多回答（1 个）

KSSV
KSSV 2017-5-23
编辑：KSSV 2017-5-23
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

类别

在 Help Center 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by