MATLAB: How to delete the duplicate rows in cell based on a particular column

cellunique

The input is:

A={[1 2 3] [2 3] [1 2 3];[2 5 8] [3 4] [1 2 3];[2 5 4]  [2 3] [1 2 3];[1 2 5] [3 4] [1 2 3]};

based on the duplication in the 2nd column,the output will be:

B={[2 5 4]  [2 3] [1 2 3];[1 2 5] [3 4] [1 2 3]};

How can I do that?

Best Answer

This assumes the second column always contains vectors of the same length, and also that you want to keep only the last occurence.

[~,idx]=unique(cell2mat(A(:,2)),'rows','last');
B=A(idx,:);

Related Solutions

MATLAB: Identifying the repeated rows in a matrix and comparing them to another matrix

Hello,

you can refer my answer as follows

clear
A= [4 4; 2 3; 4 2; 3 3; 2 3; 1 3; 3 3];
B=[1 1; 2 1; 3 1; 4 1; 1 2; 2 2; 3 2; 4 2; 1 3; 2 3; 3 3; 4 3; 1 4; 2 4; 3 4; 4 4];
n = size(A,1);
rowAinB = [];
for i = 1:n
    [LIA,LOCB] = ismember(A(i,:),B,'rows','legacy');
    if ~isempty(LOCB)
        rowAinB = [rowAinB i];
    end
end
repeatA = [];
C = unique(A,'rows','stable');
for i = 1:n
    [LIA,LOCB] = ismember(A(i,:),C,'rows','legacy');
    repeatA = [repeatA LOCB];
end
m = size(C,1);
coutrepeatA = zeros(m,1);
for i = 1:m
    idx = find(repeatA == repeatA(i));
    coutrepeatA(i) = length(idx)-1;
end

the unique of matrix A is C and number of repeated row of C is stored in vector "coutrepeatA". As you can see the results below

A =
     4     4
     2     3
     4     2
     3     3
     2     3
     1     3
     3     3
     
C =
     4     4
     2     3
     4     2
     3     3
     1     3
     
coutrepeatA =
     0
     1
     0
     1
     1

Best regards,

Trung

MATLAB: Putting the combinations of a sequence in an cell array

>> vec = 1:5;
>> fun = @(n)num2cell(combnk(vec,n),2);
>> out = arrayfun(fun,1:numel(vec),'uniformoutput',0);
>> out = vertcat(out{:});
>> out{:}
ans =
     1
ans =
     2
ans =
     3
ans =
     4
ans =
     5
ans =
     1     2
ans =
     1     3
ans =
     1     4
ans =
     1     5
ans =
     2     3
ans =
     2     4
ans =
     2     5
ans =
     3     4
ans =
     3     5
ans =
     4     5
ans =
     1     2     3
ans =
     1     2     4
ans =
     1     2     5
ans =
     1     3     4
ans =
     1     3     5
ans =
     1     4     5
ans =
     2     3     4
ans =
     2     3     5
ans =
     2     4     5
ans =
     3     4     5
ans =
     1     2     3     4
ans =
     1     2     3     5
ans =
     1     2     4     5
ans =
     1     3     4     5
ans =
     2     3     4     5
ans =
     1     2     3     4     5
>>

Best Answer

Related Solutions

MATLAB: Identifying the repeated rows in a matrix and comparing them to another matrix

MATLAB: Putting the combinations of a sequence in an cell array

Related Question