How to find rank within group

Question

Garima Sharma 2017-6-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/346314-how-to-find-rank-within-group

评论： Simon 2023-8-7

I have a dataset with 100 different groups, and between 8-11 entries in each group. I want to rank them, within a group, by the value of a variable y. How would I do this?

Concretely, if I have 2 groups with 2 people each such that: y=[1; 3; 6; 5] group_id=[1;1;2;2]

then I want a third vector: rank=[1;2;2;1]

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2017-6-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/346314-how-to-find-rank-within-group#answer_272084

编辑：Andrei Bobrov 2017-6-27

在 MATLAB Online 中打开

[~,a] = cellfun(@sort,accumarray(group_id,y,[],@(x){x}),'un',0);
rank = cell2mat(a);

or within for..end:

y=[1; 3; 6; 5];
group_id=[1;1;2;2];
rank = group_id;
a = unique(group_id);
for ii = 1:numel(a)
    t = group_id == a(ii);
    [~,rank(t)] = sort(y(t));
end

2 个评论
显示无隐藏无

Garima Sharma 2017-6-27

Thanks, this works!

Simon 2023-8-7

The result created by the cellfun-based method is different from the for-loop based method when group_id is not in sorted order. The within-group ranking is the same in both methods. But rank = cell2mat(a) put all 1st group's within-group ranks together, followed by the second group's.

I have came across similar problem and in a subsequent analysis I need to put rank as a new column side-by-side next to group_id. The cellfun-based method would give me erroneous result.

请先登录，再进行评论。

Answer 2

Jess Lovering 2017-6-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/346314-how-to-find-rank-within-group#answer_272045

在 MATLAB Online 中打开

Do you mean that you want to sort the data by a specific array? You can do this using the sort function. It will also give you the indices of the new order so you can use that to apply to the other arrays, example:

y=[1; 3; 6; 5] 
group_id=[1;1;2;2]
rank=[1;2;2;1]
[sorted_y,I]= sort(y)
sorted_group_id = group_id(I)
sorted_rank = rank(I)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Garima Sharma 2017-6-27

no, what I want to do is rank y=[1; 3; 6; 5] within its respective group_id=[1;1;2;2].

So, y(1,1) is rank 1 in group 1; y(2,1) is rank 2 in group 1. y(3,1) is rank 2 in group 2, and y(4,1) is rank 1 in group 2. I want to only input vectors y and group, and get vector rank as the output.

请先登录，再进行评论。