Creating a conditional variable or function such that

JB
2020 6 3
1 个回答
回答已采纳
更新时间：2020 6 4
2 次查看（30 天）

0 个投票

Hi, I'm struggling for hours to do this...
Suppose I have this data:
schoolid classid classsize enrollment newcolumn
1001 1 10 22 11
1001 2 12 22 11
1005 1 14 29 14.5
1005 2 15 29 14.5
1018 1 8 22 22/3
1018 2 4 22 22/3
1018 3 10 22 22/3
.
.
.
I would like to generate a function that gives "newColumn" above.
Plaese help me out. Thanks.

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

 采纳的回答

Ameer Hamza
Ameer Hamza 2020-6-3

1 个投票

Try this
schoolID = [1001 1001 1005 1005 1018 1018 1018];
enrollment = [22 22 29 29 22 22 22];
grps = findgroups(schoolID);
avg = splitapply(@(x) x(1)/numel(x), enrollment.', grps.');
newcolumn = avg(grps);

2 个评论
显示 无 隐藏 无

JB
JB 2020-6-3
Wow... Thank you so much! It worked perfectly. I don't know how it worked. I will study closely each codes. Anyways, thanks again!
Ameer Hamza
Ameer Hamza 2020-6-4
I am glad to be of help! Documentation pages will be helpful in understanding this.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by