Using unique-function to add up values

1 次查看（过去 30 天）
Lukas Netzer
Lukas Netzer 2021-5-2
回答： Matt J 2021-5-2
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!!

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

采纳的回答

Matt J
Matt J 2021-5-2
accumarray(ic, DiffTime)

更多回答（1 个）

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

类别

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

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by