fill in zeros in a matrix

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

0 votes

I would recommend replacing the zeros with NaNs and using something like this,
instead.

1 Comment

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

Asked:

on 9 Jul 2013

Community Treasure Hunt

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

Start Hunting!