How can I replace NaN elements with the nearest value in the same column?

11 次查看（过去 30 天）

显示更早的评论

sal135 2017-4-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/337273-how-can-i-replace-nan-elements-with-the-nearest-value-in-the-same-column

编辑： sal135 2017-4-27

采纳的回答： Andrei Bobrov

在 MATLAB Online 中打开

I am trying to replace NaN's in a vector field with the nearest value.

 % I have:
M=
NaN  12
18   14
NaN  NaN
NaN  NaN
NaN  16
12   NaN
12   NaN
NaN  12
16   NaN
 %I desire:
M=
18   12
18   14
12   16
12   16
12   16
12   12
12   12
16   12
16   12

Any information will be helpful. Thank you

2 个评论
显示无隐藏无

AstroGuy1984 2017-4-25

编辑：AstroGuy1984 2017-4-25

What do you mean by "nearest"? Do you mean "next good value"? Because that's what you appear to desire. For example the second NaN in column 1 is closer to 18 than 12.

sal135 2017-4-26

I would like to have the first value of NaN to have the value of the next good value. However if the last value in the column is a NaN I would like for it to have the value of the previous good value

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Andrei Bobrov 2017-4-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/337273-how-can-i-replace-nan-elements-with-the-nearest-value-in-the-same-column#answer_264492

编辑：Andrei Bobrov 2017-4-26

在 MATLAB Online 中打开

FIXED 2

m = flipud(M)
t = ~isnan(m);
ii = cumsum(t);
ii(ii == 0) = 1;
ii = bsxfun(@plus,[0,ii(end,1:end-1)],ii);
m1 = m(t);
out = flipud(m1(ii))

6 个评论
显示 4更早的评论隐藏 4更早的评论

Andrei Bobrov 2017-4-26

在 MATLAB Online 中打开

>> m = flipud(M);
t = ~isnan(m);
ii = cumsum(t);
ii(ii == 0) = 1;
ii = bsxfun(@plus,[0,ii(end,1:end-1)],ii);
m1 = m(t);
out = flipud(m1(ii))
out =
    18    12
    18    14
    12    16
    12    16
    12    16
    12    12
    12    12
    16    12
    16    12
>>