Create a matrix on the basis of other matrix

5 views (last 30 days)
Hi given a matrix
M= [ 0 4 8 6;
0 0 0 6;
0 0 0 6;
2 0 0 0;
0 0 0 0;
0 0 0 1;
0 4 7 0;
5 3 0 0;
0 0 0 6;
0 0 0 6;];
I want to create a new matrix A that contain just the diversity, no matter of the order and with no zeros.
so in this case
A = [2 4 8 6;
5 3 7 1];
Someone can help me with the code?

Accepted Answer

Fabio Freschi
Fabio Freschi on 14 Oct 2019
Edited: Fabio Freschi on 14 Oct 2019
Under the assumption that the "diversity" contains the same number of entries each row
for i = 1:size(M,2)
b(:,i) = unique(nonzeros(M(:,i)));
end
If each column can have different number of interest
b = arrayfun(@(i)unique(nonzeros(M(:,i))),1:size(M,2),'UniformOutput',false)
then you can access to the unique values of the jth row as
b{j}

More Answers (1)

Andrei Bobrov
Andrei Bobrov on 14 Oct 2019
[~,j] = find(M);
C = accumarray(j,M(M ~= 0),[],@(x){unique(x,'stable')})
if all(diff(cellfun(@numel,C)) == 0)
C = [C{:}];
end

Categories

Find more on Creating and Concatenating Matrices in Help Center and File Exchange

Tags

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!