您正在关注此问题

您将在关注的内容源中看到更新。
您可能会收到电子邮件，具体取决于您的通信预设项。

aggregate data of a dataset

3 次查看（过去 30 天）

显示更早的评论

Megan 2020-2-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset

⋮

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset

编辑： Megan 2020-2-19

采纳的回答： Sindar

Hi guys how can I aggregate data vom my dataset array?

采纳的回答

Sindar 2020-2-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#answer_415860

⋮

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#answer_415860

在 MATLAB Online 中打开

check out splitapply. You may need to change the format of your data, but it does exactly what you want:

G = findgroups(ds.seats);
mean_dist = splitapply(@mean,ds.score,G);

Switching to tables is probably a good idea:

ds = readtable("datasetT.csv");

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798159

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798159

is there not a aggregate funktion like in R?

Sindar 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798165

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798165

I'm not familiar with R, but (based on a little googling of R's aggregate function) it looks like splitapply does basically the same thing, just with a little less in the way of wrapping. Look at the documentation for examples.

Megan 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798166

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798166

Thanks Sindar

Megan 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798185

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798185

@sindar I doesnt work. I just get 2 rows with NaN :/

Megan 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798187

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798187

在 MATLAB Online 中打开

Okay I did dataset2table. That worked out. Now I have a table

but

splitapply

didn't work.

Do you know why? Now I know it's not because of dataset.

Sindar 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798188

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798188

Most likely, you have NaN's in your data. Sounds like you'll need to do some extra work (but, this will help in the future). First, try using the import tool: https://www.mathworks.com/help/matlab/ref/importtool-app.html

This should allow you to figure out why readtable isn't working. Once everything looks good, you can generate code using the arrow just under "import selection"

Then, look here for how to handle missing data (that produced those nans). Some can be done during import, too. https://www.mathworks.com/help/matlab/data_analysis/missing-data-in-matlab.html

Sindar 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798189

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798189

在 MATLAB Online 中打开

Try this to replace any missing values with 0:

fillmissing(ds,'constant',0)

Megan 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798190

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798190

Did you try it out with my table?

Megan 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798191

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798191

I didn't get your last comment :(

Megan 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798192

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798192

YOu can look at my table I dont have missing values

Sindar 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798194

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798194

编辑：Sindar 2020-2-16

在 MATLAB Online 中打开

I hadn't tried before, but this works:

ds=readtable('datasetT.xlsx');
G = findgroups(ds.Seat);
mean_dist = splitapply(@mean,ds.score,G);

mean_dist =

3.4286

3.7576

There don't seem to be any missing values or issues with readtable

Megan 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798196

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798196

Oh okay I found it

Megan 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798197

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798197

编辑：Megan 2020-2-16

I added a short version of my dataset here. in my original one I have NaN... Sorry :/

Megan 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798198

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798198

在 MATLAB Online 中打开

fillmissing(ds,'constant',0)

This is not working.

Error using fillmissing/checkArrayType (line 522)

Invalid fill constant type.

Error in fillmissing/fillTableVar (line 166)

[intConstVj,extMethodVj] = checkArrayType(Avj,intMethod,intConstVj,extMethodVj,x,true);

Error in fillmissing/fillTable (line 144)

B.(vj) =

fillTableVar(indVj,A.(vj),intMethod,intConst,extMethod,x,useJthFillConstant,useJthExtrapConstant);

Error in fillmissing (line 127)

B = fillTable(A,intM,intConstOrWinSize,extM,x,dataVars);

Sindar 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798200

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798200

在 MATLAB Online 中打开

Sorry, I haven't actually used fillmissing much, so I'm not sure what's up. Regardless, I realized removing rows with missing entries is probably better for your purpose:

ds=readtable('datasetT.xlsx');
clean_ds = rmmissing(ds);
G = findgroups(clean_ds.Seat);
mean_dist = splitapply(@mean,clean_ds.score,G);

Megan 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798202

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798202

That worked out well Thanks!!!

One last question: now I have two rows with mean values.

How can I know which row is which seat number?

Sindar 2020-2-16

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798207

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505820-aggregate-data-of-a-dataset#comment_798207

在 MATLAB Online 中打开

Look at the second output from findgroups:

[G,G_seat] = findgroups(clean_ds.Seat);

At the end, you can make a summary table:

sum_table = table(G_seat,mean_dist)

请先登录，再进行评论。

另请参阅

类别

MATLAB Language Fundamentals Data Types Tables

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

Community Treasure Hunt

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

Start Hunting!

发生错误

由于页面发生更改，无法完成操作。请重新加载页面以查看其更新后的状态。

Translated by

选择网站

选择网站以获取翻译的可用内容，以及查看当地活动和优惠。根据您的位置，我们建议您选择：。

(English)
(Deutsch)
(Français)

（简体中文）
(English)

您也可以从以下列表中选择网站：

如何获得最佳网站性能

选择中国网站（中文或英文）以获得最佳网站性能。其他 MathWorks 国家/地区网站并未针对您所在位置的访问进行优化。

美洲

América Latina (Español)
Canada (English)
United States (English)

欧洲

Belgium (English)
Denmark (English)
Deutschland (Deutsch)
España (Español)
Finland (English)
France (Français)
Ireland (English)
Italia (Italiano)
Luxembourg (English)

Netherlands (English)
Norway (English)
Österreich (Deutsch)
Portugal (English)
Sweden (English)
Switzerland
United Kingdom (English)

亚太

Australia (English)
India (English)
New Zealand (English)
中国
- 简体中文Chinese
- English
日本Japanese (日本語)
한국Korean (한국어)

联系您当地的办事处

aggregate data of a dataset

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

采纳的回答

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

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

aggregate data of a dataset

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

采纳的回答

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

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

WeChat

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

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