Using unique-function to add up values

1 view (last 30 days)
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!!

Accepted Answer

Matt J
Matt J on 2 May 2021
accumarray(ic, DiffTime)

More Answers (1)

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

Categories

Find more on Simulink in Help Center and File Exchange

Products


Release

R2021a

Community Treasure Hunt

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

Start Hunting!