Fill out zeros/NaN in array with next value

1 次查看(过去 30 天)
Hi everybody
I have the following 2 dimensional matrix:
1 NaN NaN
2 1 NaN
NaN 2 1
2 NaN NaN
NaN NaN 2
NaN NaN 2
NaN 2 NaN
What I want is to replace the NaN with the first next value that is not NaN (Looking at the first dimension (column)
1 1 1
2 1 1
2 2 1
2 2 1
2 2 2
2 2 2
2 2 2
What do I do?

回答(1 个)

Jim Hokanson
Jim Hokanson 2016-12-5
I'm not entirely sure how you are generating the output, but you should be able to do something like:
I = find(isnan(data));
for iNaN= 1:length(I)
cur_index = I(iNaN);
data(cur_index ) = data(cur_index -1);
end
This approach relies on linear indexing to get the previous value. Even if the previous value was NaN, you've overwritten it with a valid value. You are going to run into problems if you need to do something special for the first value in each column. This approach will replace the first value in a column with the last value in the previous column.
  1 个评论
Christian Frandsen
Christian Frandsen 2016-12-6
Hi Jim I have generated it manually. The problem is that I also need the first value in each column.

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by