How to delete the columns that has NaN values?

Hi!

I have this 5x5 matrix. Of them, only column 2 and 3 does not contain any NaN values. How can I write down a code that will delete the entire column which even has only one NaN value?

1      2   3     4   5
NaN    6   7     8   11
4      8   9     1   NaN
NaN    4   0     2   8
NaN    1   6     NaN 9

Answer 1

[Cris LaPierre]

I'd use rmmissing with the following syntax.

R = rmmissing(A,dim)

Since column correspond to the second dimension you would do this

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

R = 5×2

2 3 6 7 8 9 4 0 1 6

[Ashfaq Ahmed]

Awesome!