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

3 次查看（过去 30 天）

safaa 2017-3-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/332919-how-detect-duplicate-value-in-each-column-and-replace-one-value-with-zero

评论： 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));

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Stephen23 2017-4-2

See duplicate:

https://www.mathworks.com/matlabcentral/answers/333122-how-detect-duplicate-value-in-each-column-and-replace-first-value-with-zero

请先登录，再进行评论。

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

采纳的回答

Andrei Bobrov 2017-3-31

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/332919-how-detect-duplicate-value-in-each-column-and-replace-one-value-with-zero#answer_261186

编辑：Andrei Bobrov 2017-3-31

在 MATLAB Online 中打开

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更早的评论隐藏 1更早的评论

safaa 2017-4-1

is there way to make first duplicate element 0 instead of second element ?

Andrei Bobrov 2017-4-3

在 MATLAB Online 中打开

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);