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 中查找有关 Data Import and Analysis 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by