Error using matlab.internal.math.checkDataVariables Invalid grouping variables.

20 次查看（过去 30 天）

Umair Ejaz 2022-8-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1782575-error-using-matlab-internal-math-checkdatavariables-invalid-grouping-variables

评论： Juan Carlos Hernandez 2023-2-18

kindly help me solve this issue

load("stormData"); 
 summaryRegionCosts = groupsummary(stormData, "stormData.Region",['min','max','median','mean'] , "stormData.Total_Cost")
   stormDataPos = stormData.Total_cost> 0 
  summaryRegionPosCosts =   groupsummary(stormData,  "stormData.Region",   ['min','max','median','mean'],"stormData.stormDataPos")
  
  

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

Juan Carlos Hernandez 2023-2-18

在 MATLAB Online 中打开

Hi,

Here is your problem solved:

load("stormData"); 
summaryRegionCosts=groupsummary(stormData,"Region",["min","median","mean","max"],"Total_Cost")
stormDataPos=stormData(stormData.Total_Cost>=1,:)
summaryRegionPosCosts=groupsummary(stormDataPos,"Region",{"min","median","mean","max"},"Total_Cost")

请先登录，再进行评论。

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

回答（1 个）

Steven Lord 2022-8-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1782575-error-using-matlab-internal-math-checkdatavariables-invalid-grouping-variables#answer_1029825

The second input for the groupsummary function as you're calling it should be the name of a variable in your table. "stormData.Region" isn't the name of a variable, it's an expression that would extract a variable in the table. Try using just "Region" in your call instead.

15 个评论
显示 13更早的评论隐藏 13更早的评论

Umair Ejaz 2022-8-22

https://www.mathworks.com/matlabcentral/answers/1782575-error-using-matlab-internal-math-checkdatavariables-invalid-grouping-variables#comment_2326095

i have tried it but still not working

Walter Roberson 2022-8-23

在 MATLAB Online 中打开

You are attempting to pass in a logical mask stormDatapos as the 4th parameter to groupsummary, with the first parameter being a table

When you use 4 parameters to groupsummary and the first one is a table, the permitted syntaxes are

G = groupsummary(T,GROUPVARS,GROUPBINS,METHOD)
G = groupsummary(T,GROUPVARS,METHOD,DATAVARS)

Your {'min', 'max', 'median', 'mean'} or ["min", "max", "median", "mean"] is not grouping bins, so the first of the two possibilities does not apply.

Your logical vector is not a data variable name within the table, so the second of the two possibilities does not appy.

If you want to summarize only for a subset of a table, you need to construct the subset first and summarize on it. For example,

sdss = stormData(stormDataPos, :);
summaryRegionPostCosts = groupsummary(sdss, "Region", ["min", "max", "median", "mean"])

In practice you will probably need to add a list of variables to apply the summary to, as it is not clear that taking mean() of your categorical SuperRegion is meaningful.

请先登录，再进行评论。

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