How to get statistical summary

1 次查看（过去 30 天）
Mekala balaji
Mekala balaji 2018-10-16
编辑： Guillaume 2018-10-16
Hi,
I have below cell array,
Step 34
Step 56
Double 23
Stop 123
I want to get the summation and count of each category:
Desired output:
Step 90 2
Double 23 1
Stop 123 1
Continue 0 0
Here in the above example, no continue, but in some of my cases it exists. So for each scenario, I want to get the summation & count of: Step Double Stop Continue

请先登录，再回答此问题。

采纳的回答

Guillaume
Guillaume 2018-10-16
The way I'd do this is first convert your cell array to a table whose first column is of type categorical:
democell = {'Step', 34; 'Double', 56; 'Step', 23; 'Stop', 123}
demotable = table(categorical(democell(:, 1), {'Step', 'Double', 'Stop', 'Continue'}), cell2mat(democell(:, 2)), 'VariableNames', {'category', 'value'})
Your summation is then trivial:
varfun(@sum, demotable, 'GroupingVariables', 'category', 'InputVariables', 'value')
  2 个评论
Mekala balaji
Mekala balaji 2018-10-16
Output is still:
Step 2 57
Double 1 56
Stop 1 123
But I still need Continue sum is 0, count is 0.
Guillaume
Guillaume 2018-10-16
编辑：Guillaume 2018-10-16
Then, you'd have to use more or less Kevin's answer. I'd still stuff the input into a table and change the first column to categorical as it's easier to work with. I'd do the calculation like this:
catnames = categories(demotable.category)
[~, id] = ismember(demotable.category, catnames);
result = table(catnames, accumarray(id, 1, [numel(catnames), 1]), accumarray(id, demotable.value, [numel(catnames), 1]), 'VariableNames', {'category', 'count', 'sum'})

请先登录，再进行评论。

更多回答（1 个）

Kevin Chng
Kevin Chng 2018-10-16
编辑：Kevin Chng 2018-10-16
A = ["Step" "Step" "Double" "Stop" "Continue"];
B = [ 34 56 23 123 0]
[c,~,d] = unique(A);
out = [c',accumarray(d,B),countcats(categorical(A))']
  2 个评论
Mekala balaji
Mekala balaji 2018-10-16
I am getting below output, but it giving continue sum is 1, count 0. In fact the Continue should have 0 &0
Continue 0 1
Double 23 1
Step 90 2
Stop 123 1
Kevin Chng
Kevin Chng 2018-10-16
编辑：Kevin Chng 2018-10-16
change to
out = table(c',accumarray(d,B),[zeros(numel(A(B==0)))';countcats(categorical(A(B>0)))'])

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品


版本

R2016a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by