How do I filter rows of a cell based on an empty column

Question

Joel Abrahams 2017-7-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/348939-how-do-i-filter-rows-of-a-cell-based-on-an-empty-column

回答： Akira Agata 2017-7-16

Say I have a 100x100 cell. I want to get all the rows where the 8th column is empty (equal to []), and also all the rows where the 8th column is not empty. These would be two separate variables.

How would I go about doing this?

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

请先登录，再进行评论。

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

Answer 1

Akira Agata 2017-7-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/348939-how-do-i-filter-rows-of-a-cell-based-on-an-empty-column#answer_274333

在 MATLAB Online 中打开

Similarly to your previous question, the code will be like:

% 100x100 sample cell array with randomly located empty cells 
C = num2cell(randi(10,100,100));
idx = cellfun(@(x) isequal(x,3), C);
C(idx) = {''};
% Rows where the 8th column is empty
idx = cellfun(@isempty, C(:,8));
% Extract the target rows
C1 = C(idx,:);
% Others
C2 = C(~idx,:);