How Detect duplicate value in each column and replace one value with zero?

2 次查看（过去 30 天）
safaa
safaa 2017-3-31
评论： Andrei Bobrov 2017-4-3
For example A=[ 5 3 2 5 1 3 1 1 2 2; 5 8 6 6 1 4 4 2 3 3; 7 9 9 7 4 8 10 6 4 7; 8 10 10 9 9 8 10 6 5 7] In first column 5 duplicate and in five column 1 duplicate I want replace one of duplicated values with 0 i tried this but not give correct answer diffrent=find(diff(A(1:4,:))==0); A(diffrent)=zeros(size(diffrent));

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2017-3-31
编辑：Andrei Bobrov 2017-3-31
Aout = [true(1,size(A,2));diff(A)~=0].*A;
or for matrix not sorted by columns:
[m,n] = size(A);
[A1,ii] = sort(A);
[~,i1] = sort(ii);
A2 = [true(1,n);diff(A1)~=0].*A1;
Aout = A2(sub2ind([m,n],i1,repmat(0:n-1,m,1));
  3 个评论
显示 1更早的评论
Andrei Bobrov
Andrei Bobrov 2017-4-3
A1 = [5 3 9 7 1 4 10 2 3 7
8 9 10 6 1 8 10 6 5 3
7 8 2 9 4 8 1 2 2 7
5 10 6 7 1 3 4 6 4 7];
[A2,i0] = sort(A1);
A2 = [diff(A2) ~= 0;true(1,n)].*A2;
[~,i1] = sort(i0);
Aout = A2(m*(0:n-1)+i1);

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by