fill in zeros in a matrix

3 views (last 30 days)
Mate 2u
Mate 2u on 9 Jul 2013
Hi all, I have a 1000x1 double matrix. It is full of numbers....but on some situations I get multiple 0s.
Whenever I encounter 0's, I want to fill the zeros with the average of the two numbers (the nearest non zero numbers above and below).
For example, if we had 3, 4, 0 ,3 , 2, 2, 0 ,0, 0, 3, 2, 1
we would get 3, 4, 3.5, 3, 2, 2, 2.5, 2.5, 2.5, 3, 2, 1.
The shorter and faster the code, the better....please remember the amount of consecutive zeros vary.

Accepted Answer

Jan
Jan on 10 Jul 2013
x = [3, 4, 0 ,3 , 2, 2, 0 ,0, 0, 3, 2, 1];
m = (x == 0);
x(m) = interp1(find(~m), x(~m), find(m));

More Answers (1)

Matt J
Matt J on 9 Jul 2013
I would recommend replacing the zeros with NaNs and using something like this,
instead.
  1 Comment
Mate 2u
Mate 2u on 9 Jul 2013
Hi, looking for something much shorter and easier to implement, as it was a interview question....and would be nice to have something short which I can remember.

Sign in to comment.

Categories

Find more on Mathematics 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!