How to delete the columns that has NaN values?

114 次查看（过去 30 天）
Ashfaq Ahmed
Ashfaq Ahmed 2022-8-17
评论： 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

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

采纳的回答

Cris LaPierre
Cris LaPierre 2022-8-17
Ran in:
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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by