How to sort a table into five subsets?

Question

Luca 2021-4-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/812650-how-to-sort-a-table-into-five-subsets

评论： Luca 2021-4-25

subset2.mat

Hi,

I have table with stocks. Now I would like to sort them into subsets according to their size. My goal is to create the 5 subsets according to their size, with each of them holding 20% of the stocks. Unfortunatley I don't know how to do it. The size is the market capitalization. The dataset is attached to the question.

ID is stands for the diffrent stocks

years are the oberved years (1962-2016)

sumMC is the market capitalization of each stock in every year.

Does someone know how to do it?

Thank you in advance

4 个评论
显示 2更早的评论隐藏 2更早的评论

Image Analyst 2021-4-25

So what was wrong with the code I posted below? I have about 1/5 of all companies in each groups. Did you want 1/5 or the dollar amount (instead of 1/5 the number of companies) in each group? Please be clear.

Luca 2021-4-25

Sorry I didn't get anround to test it as I was answering his question. It works perfectly thank you very much.

请先登录，再进行评论。

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

Answer 1

Image Analyst 2021-4-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/812650-how-to-sort-a-table-into-five-subsets#answer_684200

在 MATLAB Online 中打开

Just use sort and linear indexing

sortedCaps = sort(marketCap, 'Ascend');
stocksPerGroup = length(sortedCaps) / 5;
% Extract stocks into group #1.
firstIndex = 1;
lastIndex = round(stocksPerGroup);
group1 = sortedCaps(firstIndex : lastIndex);
% Extract stocks into group #2.
firstIndex = lastIndex + 1;
lastIndex = round(2 * stocksPerGroup);
group2 = sortedCaps(firstIndex : lastIndex);
% Extract stocks into group #3.
firstIndex = lastIndex + 1;
lastIndex = round(3 * stocksPerGroup);
group3 = sortedCaps(firstIndex : lastIndex);
% Extract stocks into group #4.
firstIndex = lastIndex + 1;
lastIndex = round(4 * stocksPerGroup);
group4 = sortedCaps(firstIndex : lastIndex);
% Extract stocks into group #5.
firstIndex = lastIndex + 1;
lastIndex = length(sortedCaps);
group5 = sortedCaps(firstIndex : lastIndex);