MATLAB Answers

0

function to fill in zeros

Asked by Lev Mihailov on 2 Sep 2019
Latest activity Edited by 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

madhan ravi
on 2 Sep 2019
Provide the complete result for the example provided above, instead of keeping it as a mystery after someone answers.
Well, actually, I need
data=[2 0 1]
data=[2 1.5 1]
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.

1 Answer

Andrei Bobrov
Answer by Andrei Bobrov
on 2 Sep 2019
Edited by Andrei Bobrov
on 2 Sep 2019
 Accepted Answer

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);

  0 Comments

Sign in to comment.