MATLAB: Displaying result more than 50%

matrix

result = 
        {6x4 cell}
        {5x4 cell}
        {4x4 cell}
        {3x4 cell}
In which the 4th column has percentage i want to display results having more thab 50 %
the 4th column contains different percentages,i want to display above 50% pleasae help

Best Answer

r = result;
for jj = 1:numel(r)
    t = cellfun(@(x)isempty(x)|ischar(x),r{jj}(:,end));
    t2 =  cell2mat(r{jj}(~t,end)) > 50; % corrected 5
    if any(t2)
        r{jj} = r{jj}([true(nnz(t),1);t2],:);
    else
        r{jj} = [];
    end
end
r = r(~cellfun(@isempty,r),:);
OR
eg
% the initial data
 result = {{
    'Genes'      'T2&T4'    'T4&T6'    []
    'YAR029W'    'd'        'd'        [60]
    'YAR062W'    'ddu'      'ud1'      [40]
    'YBL095W'    'du'       'ud'       [60]};
{
    'Genes'      'T2&T4'    'T4&T6'    'ghgh'
    'YAR029W'    'd'        'd'        [40]
    'YAR062W'    'ddu'      'ud1'      [40]
    'YBL095W'    'du'       'ud'       [40]};
{
    'Genes'      'T2&T4'    'T4&T6'    ''
    'YAR029W'    'd'        'd'        [40]
    'YAR062W'    'ddu'      'ud1'      [70]
    'YBL095W'    'du'       'ud'       [40]}};
% solution
r = result;
for jj = 1:numel(r)
    t = cell2mat(r{jj}(2:end,end)) > 50;
    if any(t)
        r{jj} = r{jj}([true;t],:);
    else
        r{jj} = [];
    end
end
r = r(~cellfun(@isempty,r));
Related Question