function to fill in zeros
4 views (last 30 days)
Show older comments
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
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.
Accepted Answer
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);
0 Comments
More Answers (0)
See Also
Categories
Find more on Matrix Indexing in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!