Multi level sorting and filtering

Question

Mekala balaji 2015-1-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/170279-multi-level-sorting-and-filtering

评论： Mekala balaji 2015-1-17

Multilevel sorting.xlsx

Dears,

I have original data in Table1 and want to do multilevel sorting and filtering to remove repeated data and finally get unique data as in Table2. Please some one help me how to get Table2 data from Table1.

My sincere thanks in advance, Mekala

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

请先登录，再进行评论。

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

Answer 1

Shoaibur Rahman 2015-1-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/170279-multi-level-sorting-and-filtering#answer_165114

编辑：Shoaibur Rahman 2015-1-17

在 MATLAB Online 中打开

[~, ~, D] = xlsread('Multilevel_sorting.xlsx');
A = D(3:end,1:2); % your data in table 1
G = {'Group1','Group2','Group3','Group4','Group5'};
for k = 1:numel(G)
    B{k} = A(strcmp(A(:,2),G(k)));
    B{k} = [G(k); unique(B{k})]; % remove G(k) if you don't need the Group headers
end

B is your table 2. To see the elements in B, just type B{1} for Group1, B{2} for Group2 and so on.

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

Mekala balaji 2015-1-17

Sir,

I do not want to define the groups (assuming it is unknown). I Want write code to filter by uniqueness, and then I want store under each unique cell in column2 in table1, how many unique cells are present in column1.

Sincerely, Mekala

请先登录，再进行评论。