In a for loop, how do I combine rows when values are equal?
1 view (last 30 days)
Show older comments
I'm having trouble with the syntax of a for loop. In a vector, A, rows sometimes repeat values in succession. What I'd like to do is take the mean of the repeating rows' values only if they are neighboring, and leave the repeating rows' values that have now been averaged into one row as NaNs. In other words, I also need the length of the vector to stay the same.
This is the beginning of something that may work with some edits, but I have full confidence that the Matlab community has a more elegant approach. Also, I have a suspicion that there are downsides to this code that I'm not anticipating.
for i=1:length(A)-1; % -1 is to avoid an out of bounds error when attempting to access one beyond the last index.
if A(i) + A(i+1) == A(i) * 2;
A(i)=mean(A(i:i+1));
A(i+1)=NaN;
end
end
How can this code be improved?
0 Comments
Accepted Answer
Jan
on 8 May 2017
for k = 1:length(A)-1
if A(i) == A(i+1)
% A(i) = mean(A(i:i+1)); % Omit this! The mean of two equal value is the value itself
A(i+1) = NaN;
end
end
Why do you create the mean, if the values are equal? What should happen if a value is repeated mutliple times? Perhaps this is smarter:
index = [false; (diff(A(:)) == 0)];
A(index) = NaN;
More Answers (0)
See Also
Categories
Find more on Resizing and Reshaping 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!