aggregate data of a dataset

2 次查看（过去 30 天）
Megan
Megan 2020-2-16
编辑： Megan 2020-2-19
Hi guys how can I aggregate data vom my dataset array?

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

采纳的回答

Sindar
Sindar 2020-2-16
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");
  17 个评论
显示 15更早的评论
Megan
Megan 2020-2-16
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
Sindar 2020-2-16
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)

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by