Using unique-function to add up values

2 views (last 30 days)
Lukas Netzer
Lukas Netzer on 2 May 2021
Answered: Matt J on 2 May 2021
Hey guys,
I am splitting a column according to it's unique values:
[C, ia, ic] = unique(Location)
Which gives me (examplified):
C/ia/ic:
Location1 1205 8
Location2 9 8
Location3 387 2
Location4 45 2
Location5 653 8
Location6 59 8
Location7 3 1
Location8 1037 1
etc.. numbers may not match..
Now I have another colum containing DiffTime(seconds):
DiffTime:
0
23853
16835
12900
14869
40810
11700
10201
How can I add up DiffTime for each unique Location?
So that i get DiffTimeTotal for Location1, Location2, ...
Thanks for your help!!

More Answers (1)

Matt J
Matt J on 2 May 2021
Possibly faster:
totals = splitapply(@sum, DiffTime, findgroups(Location))

Community Treasure Hunt

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

Start Hunting!

Translated by