MATLAB: How to compact an array with repeated data and NaNs

nanrepeated data

Hi!
I have two vectors with measurement set points and an array with measurement values. The vectors and array contain repeated values and the array also contains NaNs. I would like to remove the repeated data and for the measurement set points where there are both a NaN and a value, I would like the value to remain.
For example, if the two vectors are called x and y and the array is called z.
x = [0 0.5 0.5 1 2]
y = [0 1 2 2 ]
z = [1 NaN 2 5 10; 7 3 3 NaN 2; 8 4 4 NaN NaN; 8 NaN 4 8 NaN]
I would like this to become
x = [0 0.5 1 2]
y = [0 1 2]
z = [1 2 5 10; 7 3 NaN 2; 8 4 8 NaN]
How do I do this in an easy way (I have quite a large array with data…)?
Thanks!

Best Answer

Brute force using loops (if there are different non-NaN values available for a particular spot, picks the max of them):
[m,n] = size(z);
for k=1:n-1
    if( x(k) == x(k+1) )
        z(:,k) = max(z(:,k:k+1),[],2);
    end
end
for k=1:m-1
    if( y(k) == y(k+1) )
        z(k,:) = max(z(k:k+1,:),[],1);
    end
end
[x,iax,~] = unique(x);
[y,iay,~] = unique(y);
z = z(iay,iax);
Related Question