How to add time from 2 arrays

1 次查看(过去 30 天)
Hi, I am a new user of Matlab. I have the following problem:
I have two columns like this way.
  • a =102 sec
  • a =135
  • a =157
  • b =189
  • b =201
  • a =222
  • a =245
  • b =290
Here the values are in seconds. I want to write a formula, which show the total duration of seconds of a and b.
For example: here total duration of a is = (157-102) + (245-222) = 78 seconds.
Please suggest me how to do it.
Thanks
  6 个评论
José-Luis
José-Luis 2014-10-16
So is your variable a table or do you have two column vectors: one with strings and the other with numbers?
SS
SS 2014-10-16
It's two column vectors: one with string and other with number.

请先登录,再进行评论。

采纳的回答

Andrei Bobrov
Andrei Bobrov 2014-10-16
C = {'a' 102
'a' 135
'a' 157
'b' 189
'b' 201
'a' 222
'a' 245
'b' 290}
cn = [C{:,2}]';
[~,~,c1] = unique(C(:,1));
t = [true;diff(c1)~=0];
s1 = accumarray(cumsum(t),cn,[],@(x)x(end)-x(1));
out = accumarray(c1(t),s1);

更多回答(1 个)

Rainer
Rainer 2014-10-16
I don't see the two columns and I don't understand what a and b are.
  1 个评论
SS
SS 2014-10-16
sorry..i corrected it:
  • a =102 sec
  • a =135
  • a =157
  • b =189
  • b =201
  • a =222
  • a =245
  • b =290

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by