How can I remove all rows from a matrix which contain NaN values?

How can I remove all rows from a matrix which contain NaN values?

For example:

>> A = [1, 2, 3; 4, NaN, 6; 7, 8, 9]

A =

     1     2     3
     4   NaN     6
     7     8     9

In matrix A defined above, I would like to remove the second row, [4, NaN, 6].

Answer 1

[MathWorks Support Team]

Use the following code to remove all rows which contain NaN values from a matrix A:

>> A = [1, 2, 3; 4, NaN, 6; 7, 8, 9];
>> A = A(~any(isnan(A), 2), :)

A =

     1     2     3
     7     8     9

Alternatively, make use of the function "rmmissing" to remove any row that contains missing data, as shown below.

>> A = [1, 2, 3; 4, NaN, 6; 7, 8, 9];
>> A = rmmissing(A)

A =

     1     2     3
     7     8     9

[Walter Roberson]

A = [1, 2, 3; 4, NaN, 6; 7, 8, 9];
A = rmmissing(A)

A = 2×3

1 2 3 7 8 9

<mw-icon class=""></mw-icon>

<mw-icon class=""></mw-icon>