filling in blank cells with nearest number

3 views (last 30 days)
John on 2 Mar 2013
Hi there,
Would anybody be able to help me with some code to 'fill in some data'.
I have a column of data with '1's and '0's with blank cell in between. I'm trying to fill in the blank cells with the nearest number.
Greatly appreciate any help. I have 105,841 rows.
Here is an example:
John on 2 Mar 2013
Hello Wayne, thanks for your reply. Yes they are rendered as NaN.

Sign in to comment.

Answers (1)

Wayne King
Wayne King on 2 Mar 2013
The question I'm not sure of from your post is how you want to deal with
1 NaN 0
0 NaN 1
Do you want the above to be assigned 1?
I'll assume that you have at most 1 NaN between numbers.
There are many ways to do this
x = [0 0 0 NaN 0 1 1 NaN 0];
indexvec = 1:length(x);
idx = isnan(x);
indexvec = indexvec(idx>0);
x(indexvec) = max(x(indexvec-1),x(indexvec+1));
The above code assigns a 1 to both
1 NaN 0
0 NaN 1
It also assigns 0 to
0 NaN 0
and 1 to
1 NaN 1
John on 2 Mar 2013
Hello Wayne,
Sorry for bothering you, I'm just wondering if you had time to consider my problem any further.
Kind Regards

Sign in to comment.


Community Treasure Hunt

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

Start Hunting!