Removing entire column if any of the value in that column contains a NaN

Question

Wietze Zijpp 2022-4-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1688529-removing-entire-column-if-any-of-the-value-in-that-column-contains-a-nan

回答： Voss 2022-4-4

采纳的回答： Voss

I am trying to clean up my dataset. Therfore I want to remove any columns that contain any Nan values.

The dataset is of form table. I have tried a few approaches but did not succeed

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

请先登录，再进行评论。

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

Answer 1

Voss 2022-4-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1688529-removing-entire-column-if-any-of-the-value-in-that-column-contains-a-nan#answer_934629

在 MATLAB Online 中打开

% make a table with some NaNs:
A = magic(5);
A([7 15]) = NaN;
t = array2table(A)
t = 5×5 table
    A1    A2     A3     A4    A5
    __    ___    ___    __    __

    17     24      1     8    15
    23    NaN      7    14    16
     4      6     13    20    22
    10     12     19    21     3
    11     18    NaN     2     9
% remove columns/table-variables with any NaNs:
t(:,any(isnan(t{:,:}),1)) = []
t = 5×3 table
    A1    A4    A5
    __    __    __

    17     8    15
    23    14    16
     4    20    22
    10    21     3
    11     2     9