Hi! I'm trying to extract the top N elements of each kind in a matrix

Question

Joshua Santiago 2016-3-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/271111-hi-i-m-trying-to-extract-the-top-n-elements-of-each-kind-in-a-matrix

评论： Joshua Santiago 2016-3-2

say I have a matrix that looks like [10 1 ; 20 1; 11 2; 29 2; 40 3; 50 1; 100 3; 90 2] now I'd like to get the least N elements of each kind so the output here if N=2 would be [10 1;20 1; 11 2; 23 2; 40 3; 100 3] running out of ideas Thaaaanks!

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2016-3-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/271111-hi-i-m-trying-to-extract-the-top-n-elements-of-each-kind-in-a-matrix#answer_212074

在 MATLAB Online 中打开

It's not clear what 'kind' refers to, it looks like it's the value of the second column. In which case,

m = [10 1 ; 20 1; 11 2; 29 2; 40 3; 50 1; 100 3; 90 2];
rowsbycol2 = arrayfun(@(v) m(m(:, 2) == v, :), unique(m(:, 2)), 'UniformOutput', false);
first2values = cellfun(@(r) r(1:2, :), rowsbycol2, 'UniformOutput', false);
first2values = vertcat(first2values{:})

2 个评论
显示无隐藏无

Joshua Santiago 2016-3-2

yup the value of the second value :D it works, thaaaaanks

Joshua Santiago 2016-3-2

hmm is there a way to make it sort of adaptive? since there are some cases where I need to get the top N elements but the number of elements for one kind is less than N. if I set the code to find the first 4 values I get this: ndex exceeds matrix dimensions.

Error in @(r)r(1:4,:)

Error in test (line 3) first4values = cellfun(@(r) r(1:4, :), rowsbycol2, 'UniformOutput', false);

请先登录，再进行评论。