How to delete the columns that has NaN values?

Question

Ashfaq Ahmed 2022-8-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1780915-how-to-delete-the-columns-that-has-nan-values

评论： Ashfaq Ahmed 2022-8-17

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Cris LaPierre 2022-8-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1780915-how-to-delete-the-columns-that-has-nan-values#answer_1028100

在 MATLAB Online 中打开

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