how to create group from matrix

5 views (last 30 days)
pipin
pipin on 7 Aug 2023
Commented: Voss on 7 Aug 2023
hi, i want to do table group :
1 column :3,5,9,12
2 column: 4,6,7,8,10,11
3 colum (no..because this element are identical at colum 1 )
..
the column with all zero element to be not insert! (and the column egual )
finally i get this matrix (colum 5,6,7,8 are clone...i not insert it in the group)
1 column :3,5,9,12,0,0
2 column: 4,6,7,8,10,11
i try to use world reserved "unique" but i can't do it

Accepted Answer

Voss
Voss on 7 Aug 2023
Edited: Voss on 7 Aug 2023
M = [0 0 3 4 3 4 4 4; 0 0 5 6 5 6 6 6; 0 0 9 7 9 7 7 7; 0 0 12 8 12 8 8 8; 0 0 0 10 0 10 10 10; 0 0 0 11 0 11 11 11; 0 0 0 0 0 0 0 0; 0 0 0 0 0 0 0 0; 0 0 0 0 0 0 0 0]
M = 9×8
0 0 3 4 3 4 4 4 0 0 5 6 5 6 6 6 0 0 9 7 9 7 7 7 0 0 12 8 12 8 8 8 0 0 0 10 0 10 10 10 0 0 0 11 0 11 11 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
% unique() by column:
M = unique(M.','rows','stable').'
M = 9×3
0 3 4 0 5 6 0 9 7 0 12 8 0 0 10 0 0 11 0 0 0 0 0 0 0 0 0
% remove all-0 rows:
M(all(M == 0,2),:) = [];
% remove all-0 columns:
M(:,all(M == 0,1)) = [];
disp(M);
3 4 5 6 9 7 12 8 0 10 0 11
  4 Comments
pipin
pipin on 7 Aug 2023
thank you for explenation

Sign in to comment.

More Answers (0)

Categories

Find more on Matrices and Arrays in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!