How can I remove rows with only zeros if the first column has the row names?

Can someone please tell me how I can remove the rows that contains only zeros when the first column has the row names? I have tried using the code below found on another Q&A, but it comes back with an error saying 'Error using any. Invalid data type. First argument must be numeric or logical'.

a =   
    glucose    7     2     5
    sucrose    0     0     0
    amylose    2     3     0
    fructose   4     5     0
    cellulose  0     0     0
    galactose  2     0     1
    
b = a(any(a,2),:); 

% What I would like b to look like: 

b = 
    glucose    7     2     5    
    amylose    2     3     0
    fructose   4     5     0
    galactose  2     0     1

Answer 1

[Bhaskar R]

You can do this in table/cell data type of variable a here i am taking table data type

Your variable a in table initialization as

% initialize your data
Names = {'glucose';'sucrose';'amylose'; 'fructose';'cellulose'; 'galactose'};
col1 = [7;0;2;4;0;2];
col2 = [2;0;3;5;0;0];
col3 = [5;0;0;0;0;1];
a = table(Names, col1, col2, col3, 'VariableNames', {'Names' 'col1' 'col2' 'col3'})

Now your data displays as table format as

a = 

       Names       col1    col2    col3
    ___________    ____    ____    ____

    'glucose'      7       2       5   
    'sucrose'      0       0       0   
    'amylose'      2       3       0   
    'fructose'     4       5       0   
    'cellulose'    0       0       0   
    'galactose'    2       0       1

Now remove the rows those all values are 0s

    ind = find(~all(a{1:end, {'col1','col2', 'col3'}}==0, 2));    % index values of the all 0s rows
    b = a(ind, :);    % your required result

[Georgina Wong]

Thank you so much for your reply!

[Bhaskar R]

It's my pleasure !! Cheers