Changing duplicates in an array to zero?
3 views (last 30 days)
Show older comments
Dominic Green
on 25 Mar 2014
Answered: Jos (10584)
on 25 Mar 2014
SO I have an array that looks like:
0 0 6 6 3 3
Basically my question is, how do you check for a duplicate value and if there is a duplicate existing, keep the first value, but set the second value to zero.
The result would be:
0 0 6 0 3 0
Thanks in advance, Dom
2 Comments
Joseph Cheng
on 25 Mar 2014
Are you just talking about consecutive duplicate values? such as [0 0 6 6 3 3 6 6 3 3] turns to [ 0 0 6 0 3 0 6 0 3 0]
or all duplicate values? such as [ 0 0 6 3 6 3] becomes [0 0 6 3 0 0].
Accepted Answer
Joseph Cheng
on 25 Mar 2014
Edited: Joseph Cheng
on 25 Mar 2014
here is a simple thing i just threw together. Hopefully it helps. As you can see what i'm doing below is finding the differences using diff() which subtracts adjacent values. when offset by x(1) and you can see that the zero values in y line up with the duplicate values found in x. using the find function you can get the index of zero values when y is zero. then you can substitute the values (here i used z) for zero.
x = [1 1 6 6 3 3 2 3 4 6 6 3 3 2 2 2 3 3 3]
y = [ x(1) diff(x)]
y = find(y==0);
z = x
z(y)=0
if it is all duplicate values as i asked in my earlier comment. Still thinking about that one.
3 Comments
Joseph Cheng
on 25 Mar 2014
simpler way, you can also use [C,IA,IC] = unique(x,'stable')and it'll give you the index of the first occurrence in IA for that number. and then you can set the rest into 0
More Answers (1)
Jos (10584)
on 25 Mar 2014
x = [1 1 6 6 3 3 2 3 4 6 6 3 3 2 2 2 3 3 3]
y = zeros(size(x))
[~,i] = unique(x,'first')
y(i) = x(i)
0 Comments
See Also
Categories
Find more on Creating and Concatenating Matrices 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!