MATLAB: Combining unique values and counting

matrix manipulation

in result{1,1}
'Pr1'    'P'  
'Par2'  'PSO'    
'Par3'  'MPSO'    
'Par4'  'SOP'    
'Par5'  'MPSO'    
'Par6'  'SOPM'    
'Par7'  'SOP'    
Is it possible to get the result as
result{1,1}
'Par1'    'P'
'Par2'  'PSO' 
'Par4'  'SOP'
'Par7'  'SOP'
'Total'   3 (PSO ,SOP are same)
'Pr1'    'P'
'Par3'  'MPSO'  
'Par5'  'MPSO'    
'Par6'  'SOPM'
'Total'   3 (MPSO,SOPM are same)
plese help

Best Answer

one way
The initial data cell array result
result={{
'Pr1'    'P'  
'Par2'  'PSO'    
'Par3'  'MPSO'    
'Par4'  'SOP'    
'Par5'  'MPSO'    
'Par6'  'SOPM'    
'Par7'  'SOP'};
{
'Pr1'    'P'  
'Par2'  'POS'    
'Par3'  'MPSO'    
'Par4'  'SOP'    
'Par5'  'MPSO'    
'Par6'  'SPO'    
}}
r = result;
for jj = 1:numel(r)
    w = r{jj};
    [b,b,b] = unique(cellfun(@sort,w(2:end,2),'un',0));
    c = histc(b,1:max(b));
    [i1,i1] = sort(b);
    n = numel(c);
    d = reshape([repmat({w(1,:)},n,1),mat2cell(w(i1+1,:),c,size(w,2)),...
                  num2cell([repmat({'Total'},n,1) num2cell(c)],2)]',[],1);
    r{jj} = cat(1,d{:});
end
Related Question