MATLAB: How to deal with this

code generationretag

Hi,

I have a large matrix that is generated in a simulation.

I have noticed that some of the columns are NAN (entire column).

Is there a way to

1) get the number of columns with NAN

2) delete the columns with NAN values

Thanks

Best Answer

find( any(isnan(YourMatrix)) )

and

YourMatrix(:, any(isnan(YourMatrix))) = [];

Related Solutions

MATLAB: Find nan and eliminate it in matrix

The reason that a vector rather than a matrix is returned is that MATLAB doesn't know that your "mask" is going to still be rectangular. For example, if your input had been

A = [1 2; 3 NaN];

then your code wouldn't be able to return a matrix.

As Walter's question suggests, you'll need to decide what to do about partial-NaN rows. Probably one of the following is what you want:

% Remove rows with all NaN:
A(all(isnan(A),2),:) = []
% Remove row with any NaN:
A(any(isnan(A),2),:) = []

You could do the analogous operations on columns by changing the 2's to 1's (and using the semicolon in the first index instead of the second).

MATLAB: I have a text file with three column, some values are 0 and NaN, want to remove that rows in which third column having 0 and NaN.

nan_or_zero = YourMatrix(:,3) == 0 | isnan(YourMatrix(:,3));
YourMatrix(nan_or_zero,:) = [];  %delete them

Best Answer

Related Solutions

MATLAB: Find nan and eliminate it in matrix

MATLAB: I have a text file with three column, some values are 0 and NaN, want to remove that rows in which third column having 0 and NaN.

Related Question