Multi level sorting and filtering
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (1)
Shoaibur Rahman
el 17 de En. de 2015
Editada: Shoaibur Rahman
el 17 de En. de 2015
[~, ~, 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.
Ver también
Categorías
Más información sobre Tables en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!