MATLAB: Delete rows from cell array

cell arraysdelete row

I have a cell array of 11×8761 and I want to delete entire rows when the value in column 9 or 6 are equal to []. How do I delete the rows without deleting the entire column as well?

Best Answer

emptycells = cellfun(@isempty, yourcellarray);    %find empty cells in the whole cell array
yourcellarray(any(emptycells(:, [6 9]), 2), :) = []; %remove rows for which any of column 6 or 9 is empty

Related Solutions

MATLAB: Convert an 18×1 cell array in a 3×6 cell array

reshape(cell_array,3,[])

MATLAB: Delete columns in a struct array

"I want to delete the columns of each struct". No, you want to delete the columns of the cell array, if present, contained in the 'bcd' field of each struct. It's important to use proper terminology so you can be understood. It also helps in finding out how to solve the problem:

for siter = 1:numel(E)     %iterate over each structure
   c = E(siter).bcd;       %get cell array in field 'bcd' of structure
   if iscell(c)            %some structures don't have a cell array in the field
       emptycell = cellfun(@isempty, c);  %find empty columns of cell array    
       c(emptycell) = [];  %delete empty cell
       E(siter).bcd = c;   %and put back in structure field
   end
end

Or in a more compact form (but slightly more difficult to understand

for siter = 1:numel(E)
    if iscell(E(siter).bcd)
       E(siter).bcd(cellfun(@isempty, E(siter).bcd)) = [];
    end
end

Best Answer

Related Solutions

MATLAB: Convert an 18×1 cell array in a 3×6 cell array

MATLAB: Delete columns in a struct array

Related Question