How can I remove columns that contain only NaNs from a cell array?

2 次查看（过去 30 天）

MathWorks Support Team 2014-6-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/133558-how-can-i-remove-columns-that-contain-only-nans-from-a-cell-array

回答： MathWorks Support Team 2014-6-10

I have a cell array that contains NaNs. Some columns only contain NaNs. How can I detect these columns and remove them from the cell array?

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

采纳的回答

MathWorks Support Team 2014-6-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/133558-how-can-i-remove-columns-that-contain-only-nans-from-a-cell-array#answer_140266

% Create some data
A = {2, NaN, 3; NaN, NaN, 'text'; 5, NaN, 6};
% Create an anonymous function to detect NaNs
f = @(x) any(isnan(x));
% Detect where there are NaNs
B = cellfun(f, A);
% Now detect columns that contain ONLY NaNs
C = all(B);
% Remove these columns
A(:,C) = [];