aggregate data of a dataset

4 views (last 30 days)
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 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");
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!