splitapply table for zscore

2017 11 13
1 个回答
回答已采纳
更新时间：2017 11 16
5 次查看（30 天）

0 个投票

I have a table in the format:
Group Score
A 3
B 7
C 18
A 10
How do I combine the splitapply function for table variables with zscore , such that it calculates zscore(Score) according to Group rather than the whole table?
I have tried:
[G,results] = findgroups(Table.Group);
ZS = splitapply(@zscore,Table.Score,G);
results.ZS = ZS

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

 采纳的回答

Peter Perkins
Peter Perkins 2017-11-16

0 个投票

splitapply is more for computing scalar summaries. Try using varfun, with a grouping variable, returning a table. Something like
t2 = varfun(@zscore,t,'GroupingVariable','Group')

3 个评论
显示 1更早的评论 隐藏 1更早的评论

UQFG
UQFG 2017-11-16
Thanks, that does seem to be appropriate... however, when I try to apply it, I get the following errors:
Error using getGroupingVarOrTime (line 13) Unrecognized variable name 'Table.Group'.
Error in tabular/varfun (line 130) groupVars = getGroupingVarOrTime(groupVars, a);
Peter Perkins
Peter Perkins 2017-11-16
I'm guessing you have a table named 'Table' (which is probably not a great idea), and a variable in it named 'Group'. The error is telling you that you do not have a variable named 'Table.Group'.
UQFG
UQFG 2017-11-16
编辑：UQFG 2017-11-16
I actually don't... I just used those names as generic examples!
I just realised that you don't need the "Table." in front of the Group name... so the code that works is:
ZS=varfun(@zscore,Table,'GroupingVariables','Group')
Whereas what I had before was:
ZS=varfun(@zscore,Table,'GroupingVariables','Table.Group')

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by