How do I filter rows of a cell based on an empty column
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Joel Abrahams
el 16 de Jul. de 2017
Respondida: Akira Agata
el 16 de Jul. de 2017
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 comentarios
Respuesta aceptada
Akira Agata
el 16 de Jul. de 2017
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 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Bartlett en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!