function to fill in zeros

5 views (last 30 days)
Lev Mihailov
Lev Mihailov on 2 Sep 2019
Edited: Andrei Bobrov on 2 Sep 2019
Hello! I have an array of data where there are zeros and I need to replace them. How can I do this?
data=[100 95 0 90 0 85 0 0 70 65 ] % as it is
data=[100 95 92.5 90 87.5 85 ] % and so it is necessary
is there a special function in matlab for this?
  5 Comments
Lev Mihailov
Lev Mihailov on 2 Sep 2019
Well, actually, I need
data=[2 0 1]
data=[2 1.5 1]
Adam
Adam on 2 Sep 2019
I'm guessing you want to replace 0s with the mean of the values either side of them, but as madhan ravi says, if you cut off a fundamental part of the example it's impossible to know. Replacing individual zeros with the mean of values either side is easy. Replacing zeros when you get multiple of them in a row is a little less clearly defined.

Sign in to comment.

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 2 Sep 2019
Edited: Andrei Bobrov on 2 Sep 2019
data=[100 95 0 90 0 85 0 0 70 65 ]';
data(data == 0) = nan;
new_data = fillmissing(data,'linear');
or
ii = (1:numel(data));
lo = data ~= 0;
new_data = interp1(ii(lo),data(lo),ii);

More Answers (0)

Products

Community Treasure Hunt

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

Start Hunting!