aggregate data of a dataset

4 views (last 30 days)
Megan
Megan on 16 Feb 2020
Edited: Megan on 19 Feb 2020
Hi guys how can I aggregate data vom my dataset array?

Accepted Answer

Sindar
Sindar on 16 Feb 2020
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 Comments
Sindar
Sindar on 16 Feb 2020
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)

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!