Create mean y values by multiple groups in one graph

Question

ektor 2024-4-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2101801-create-mean-y-values-by-multiple-groups-in-one-graph

编辑： Adam Danz 2024-4-2

Dear all, I have a snippet of my panel

id 	Year 	y 	Cat1 	Cat2 	Cat3 	Cat4
2000 	45 	1 	0 	0 	0
2001 	56 	1 	0 	0 	0
2002 	23 	1 	0 	0 	0
2003 	56 	1 	0 	0 	0
2004 	45 	1 	0 	0 	0
2000 	45 	0 	1 	0 	0
2001 	90 	0 	1 	0 	0
2002 	35 	0 	1 	0 	0
2003 	79 	0 	1 	0 	0
2004 	32 	0 	1 	0 	0

Ofcourse my full panel has id=30 and Year=5 .

I want to find the mean values of y by Cat1, up to Cat4, when each Cat takes the value of 1. And then I want to plot a bar chart of these mean values of y against the X axis that will contain the labels Cat1,..., Cat4 in a vertical position.

Is that possible to do that in Matlab?

If it is not clear, please let me know!

Many thanks in advance!

4 个评论
显示 2更早的评论隐藏 2更早的评论

Mann Baidi 2024-4-2

Okay, thanks for the clarification.

As per my understanding of the question, you would like to plot the data from Cat1 Cat2.... and y column, right?

ektor 2024-4-2

yes exactly

请先登录，再进行评论。

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

Answer 1

Star Strider 2024-4-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2101801-create-mean-y-values-by-multiple-groups-in-one-graph#answer_1434946

编辑：Star Strider 2024-4-2

在 MATLAB Online 中打开

Try this —

T1 = array2table([1 	2000 	45 	1 	0 	0 	0
1 	2001 	56 	1 	0 	0 	0
1 	2002 	23 	1 	0 	0 	0
1 	2003 	56 	1 	0 	0 	0
1 	2004 	45 	1 	0 	0 	0
2 	2000 	45 	0 	1 	0 	0
2 	2001 	90 	0 	1 	0 	0
2 	2002 	35 	0 	1 	0 	0
2 	2003 	79 	0 	1 	0 	0
2 	2004 	32 	0 	1 	0 	0], 'VariableNames',{'id','Year','y','Cat1','Cat2','Cat3','Cat4'})
T1 = 10x7 table
    id    Year    y     Cat1    Cat2    Cat3    Cat4
    __    ____    __    ____    ____    ____    ____

    1     2000    45     1       0       0       0  
    1     2001    56     1       0       0       0  
    1     2002    23     1       0       0       0  
    1     2003    56     1       0       0       0  
    1     2004    45     1       0       0       0  
    2     2000    45     0       1       0       0  
    2     2001    90     0       1       0       0  
    2     2002    35     0       1       0       0  
    2     2003    79     0       1       0       0  
    2     2004    32     0       1       0       0  
Cat_mean = NaN(2, 4);
for k = 1:4
Cat_mean(:,k) = accumarray(1+T1{:,k+3}, 1, [], @(x)mean(T1.y(x)));
end
Cat_mean
Cat_mean = 2x4
    45    45    45    45
    45    45    45    45
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>

There are several ways to do this in MATLAB. This is the approach that I usually use.

for k = 1:4

Catu(:,k) = unique(T1{:,k+3},'stable');

end

Catu

Catu = 2x4

1 0 0 0 0 1 0 0

figure

hold on

for k = 1:4

bar(k,Cat_mean(:,k), 'stacked')

end

hold off

xlabel('Cat')

ylabel('Counts')

EDIT — Added bar chart.

.

4 个评论
显示 2更早的评论隐藏 2更早的评论

Star Strider 2024-4-2

在 MATLAB Online 中打开

My pleasure!

I am not certain what you want.

Try this —

T1 = array2table([1 2000 45 1 0 0 0

1 2001 56 1 0 0 0

1 2002 23 1 0 0 0

1 2003 56 1 0 0 0

1 2004 45 1 0 0 0

2 2000 45 0 1 0 0

2 2001 90 0 1 0 0

2 2002 35 0 1 0 0

2 2003 79 0 1 0 0

2 2004 32 0 1 0 0], 'VariableNames',{'id','Year','y','Cat1','Cat2','Cat3','Cat4'})

T1 = 10x7 table

id Year y Cat1 Cat2 Cat3 Cat4 __ ____ __ ____ ____ ____ ____ 1 2000 45 1 0 0 0 1 2001 56 1 0 0 0 1 2002 23 1 0 0 0 1 2003 56 1 0 0 0 1 2004 45 1 0 0 0 2 2000 45 0 1 0 0 2 2001 90 0 1 0 0 2 2002 35 0 1 0 0 2 2003 79 0 1 0 0 2 2004 32 0 1 0 0

% Cat_mean = NaN(2, 4);

for k = 1:2%4

Cat_mean(:,k) = accumarray(T1{:,k+3}(T1{:,k+3} ~= 0), 1, [], @(x)mean(T1.y(x)));

end

Cat_mean

Cat_mean = 1x2

45 45

for k = 1:4

Catu(:,k) = unique(T1{:,k+3},'stable');

end

Catu

Catu = 2x4

1 0 0 0 0 1 0 0

figure

hold on

for k = 1:2%4

bar(k,Cat_mean(:,k), 'stacked')

end

hold off

set(gca,'XTick',(1:4))

xlabel('Cat')

ylabel('Counts')

This is not going to work correctly (without some restrictions) with the example data, however it probably will with the full data set.

.

ektor 2024-4-2

can this grapn be inverted and put the names instead of 1 2?

Many thanks

Star Strider 2024-4-2

在 MATLAB Online 中打开

The easiest way —

T1 = array2table([1 2000 45 1 0 0 0

1 2001 56 1 0 0 0

1 2002 23 1 0 0 0

1 2003 56 1 0 0 0

1 2004 45 1 0 0 0

2 2000 45 0 1 0 0

2 2001 90 0 1 0 0

2 2002 35 0 1 0 0

2 2003 79 0 1 0 0

2 2004 32 0 1 0 0], 'VariableNames',{'id','Year','y','Cat1','Cat2','Cat3','Cat4'})

T1 = 10x7 table

id Year y Cat1 Cat2 Cat3 Cat4 __ ____ __ ____ ____ ____ ____ 1 2000 45 1 0 0 0 1 2001 56 1 0 0 0 1 2002 23 1 0 0 0 1 2003 56 1 0 0 0 1 2004 45 1 0 0 0 2 2000 45 0 1 0 0 2 2001 90 0 1 0 0 2 2002 35 0 1 0 0 2 2003 79 0 1 0 0 2 2004 32 0 1 0 0

% Cat_mean = NaN(2, 4);

for k = 1:2%4

Cat_mean(:,k) = accumarray(T1{:,k+3}(T1{:,k+3} ~= 0), 1, [], @(x)mean(T1.y(x)));

end

Cat_mean

Cat_mean = 1x2

45 45

for k = 1:4

Catu(:,k) = unique(T1{:,k+3},'stable');

end

Catu

Catu = 2x4

1 0 0 0 0 1 0 0

figure

hold on

for k = 1:2%4

bar(k,Cat_mean(:,k), 'stacked')

end

hold off

set(gca,'XTick',(1:4), 'XTickLabel',compose('Cat%d',1:4))

% xlabel('Cat')

ylabel('Counts')

Another option is to use categorical tick labels, however that causes significant problems if you want to add anything numeric later, so I would not recommend it.

.

请先登录，再进行评论。

Answer 2

Adam Danz 2024-4-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2101801-create-mean-y-values-by-multiple-groups-in-one-graph#answer_1435346

编辑：Adam Danz 2024-4-2

在 MATLAB Online 中打开

Use groupsummary to compute the means of each group. Then plot the results using bar() with categorical x values.

This assumes "1" does not appear in more than 1 group.

% Input table

T = array2table([1 2000 45 1 0 0 0

1 2001 56 1 0 0 0

1 2002 23 1 0 0 0

1 2003 56 0 1 0 0

1 2004 45 0 1 0 0

2 2000 45 0 0 1 0

2 2001 90 0 0 1 0

2 2002 35 0 0 0 1

2 2003 79 0 0 0 1], ...

'VariableNames',{'id','Year','y','Cat1','Cat2','Cat3','Cat4'});

% Compute group means

groups = {'Cat1','Cat2','Cat3','Cat4'};

mu = groupsummary(T,groups,'mean','y')

mu = 4x6 table

Cat1 Cat2 Cat3 Cat4 GroupCount mean_y ____ ____ ____ ____ __________ ______ 0 0 0 1 2 57 0 0 1 0 2 67.5 0 1 0 0 2 50.5 1 0 0 0 3 41.333

% Get the group order so ensure the groups are in the same order as the

% means.

groupOrder = varfun(@find,mu(:,1:numel(groups)),'OutputFormat','uniform');

means = mu.mean_y(groupOrder);

% Plot results

bar(categorical(groups),means)

ylabel('mean')

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Create mean y values by multiple groups in one graph

4 个评论
显示 2更早的评论隐藏 2更早的评论

回答（2 个）

4 个评论
显示 2更早的评论隐藏 2更早的评论

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

另请参阅

类别

标签

Community Treasure Hunt

Create mean y values by multiple groups in one graph

4 个评论 显示 2更早的评论隐藏 2更早的评论

回答（2 个）

4 个评论 显示 2更早的评论隐藏 2更早的评论

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

另请参阅

类别

标签

Community Treasure Hunt

4 个评论
显示 2更早的评论隐藏 2更早的评论

4 个评论
显示 2更早的评论隐藏 2更早的评论

0 个评论
显示 -2更早的评论隐藏 -2更早的评论