Replace NaN with next element in Multidimensional Array

[Ben Wilson]

I have a a multidimensional array (49x49x49) which has NaN values scattered randomly.

For each NaN, I want to replace the value with the previous non NaN value.

e.g. if i had a 3 x 3 matrix

4 7 9
2 7 NaN
1 2 NaN

should become

4 7 9
2 7 7
1 2 2

I have 3 dimensions [i,j,k], but it doesn't matter which dimension I move back in, so long as it is an adjacent element.

Anybody have a solution to my problem?EDIT:

I guess I could make several loops, find the NaNs and replace e.g i with i-1. But shouldn't there be a more efficient way in Matlab?

 

[cpscdave]

How is the data loaded into the array?
Could you modify the loading to make the adjustments then?
Or at least create a list of indexes so you don't have to search through the array again?

 

[Ben Wilson]

How is the data loaded into the array?
Could you modify the loading to make the adjustments then?
Or at least create a list of indexes so you don't have to search through the array again?

no sadly not

 

[cpscdave]

Sadly the only way I know to do it then would be via 3 nested loops. 49*49*49 shouldn't take too long.

 

[kreil]

Check out the repnan function on the File Exchange:

http://www.mathworks.com/matlabcent...content/repnan/html/repnan_documentation.html

It has several options for interpolation. Notice, however, that it only works on 1-D arrays. You'll want to transform your N-D array into a vector, use repnan, then reshape back into the original size:

B = repnan(A(:));
A = reshape(B,size(A))

 

[mfig]

What if the first element is a nan? What if a nan is on the an i=1 edge so that there is no i-1 value? This problem can be quickly solved once those questions are addressed.

 

[Ben Wilson]

What if the first element is a nan? What if a nan is on the an i=1 edge so that there is no i-1 value? This problem can be quickly solved once those questions are addressed.

"NaN values scattered randomly."

 

[mfig]

"NaN values scattered randomly."

That does not answer my question. In your example you replace one nan by the 7 to its left. You are replaced the other nan with the two to its left. What if the nan is on the left-hand column?

 

[Image Analyst]

Here is a 2-D example:

% Create sample data
data = randi(99, 10, 10);
% Introduce 7 nans at random locations
data(randperm(numel(data), 7)) = nan
% Determine location of nans.
nanMap = isnan(data);
% Need to get rid of nan's for imtranslate.
data(nanMap) = -1
% Make an array shifted one column to the right.
replacements = imtranslate(data, [1, 0])
% Initialize a copy of data for our output.
output = data;
% Replace nan's with element to the left
output(nanMap) = replacements(nanMap)

 

[Drazick]

vNanIdx = find(isnan(mData));

mData(vNanIdx) = mData(vNanIdx - 1);

Remember MATLAB is Column Major, hence if the Previous item is according to the row, permute the array accordingly (Or use something which depends on the dimensions of the array instead 1).

Pay attention it won't work if the first item is NaN.

 

[FactChecker]

Pay attention it won't work if the first item is NaN.

But that is easy to fix as a special case with one line.