MATLAB: How to remove NaN values from a matrix and retain matrix shape

MATLABnan

Say for example I have the following array

X = [1 3 4; 5 6 8; NaN NaN NaN]

X =

1 3 4

5 6 8

NaN NaN NaN

I want to get rid of all the NaN values so I use

X(~isnan(X))

ans =

Now the array has changed from a 3×3 to a 1×6. I want to be able to retain the matrix layout and only remove the NaN values giving a 2×3

X =

1 3 4

5 6 8

Thanks

Best Answer

X(all(isnan(X),2),:)=[]

Related Solutions

MATLAB: How to eliminate Repeated NaNs in a array

% Demo data
x = [1:5 nan nan nan nan nan nan, 7:10, nan, 12, nan, 13:15, nan nan nan 19 ]; 
keepIdx = ~isnan(x);                          % keep all non-nans  
keepIdx(logical([1,diff(~keepIdx)])) = true;  % keep first of consecutive nans
x = x(keepIdx); % remove unwanted values from x
y = y(keepIdx); % remove unwanted values from y

MATLAB: Removing NaN from matrix

Exactly: This cannot work, because all columns of a matrix must have the same number of rows. You cannot remove all NaNs and keep the shape of the matrix. You have to decide, what you want instead:

X = X(~any(isnan(X, 2)))
X = X(~all(isnan(X, 2)))
X = X(~isnan(X))

Or perhaps you want a cell array containing the different columns vectors?

Best Answer

Related Solutions

MATLAB: How to eliminate Repeated NaNs in a array

MATLAB: Removing NaN from matrix

Related Question