How do I sort the max values from a matrix ?

2017 5 23
2 个回答
回答已采纳
更新时间：2017 5 23
9 次查看（30 天）

0 个投票

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

1 个投票

[~, 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

0 个投票

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

类别

在 帮助中心 和 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