fill in zeros in a matrix

5 visualizzazioni (ultimi 30 giorni)
Mate 2u
Mate 2u il 9 Lug 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.

Risposta accettata

Jan
Jan il 10 Lug 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));

Più risposte (1)

Matt J
Matt J il 9 Lug 2013
I would recommend replacing the zeros with NaNs and using something like this,
instead.
  1 Commento
Mate 2u
Mate 2u il 9 Lug 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.

Accedi per commentare.

Categorie

Scopri di più su Mathematics in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by