How do I filter rows of a cell based on an empty column
2 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
採用された回答
Akira Agata
2017 年 7 月 16 日
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,:);
0 件のコメント
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Performance and Memory についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!