MATLAB Answers

SS
0

How to add time from 2 arrays

Asked by SS
on 16 Oct 2014
Latest activity Answered by Andrei Bobrov
on 16 Oct 2014
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 Comments

SS
on 16 Oct 2014
its actually two columns..I just put an = between them.Here, a is in one column and 102 in other coloumn
José-Luis
on 16 Oct 2014
So is your variable a table or do you have two column vectors: one with strings and the other with numbers?
SS
on 16 Oct 2014
It's two column vectors: one with string and other with number.

Sign in to comment.

2 Answers

Answer by Andrei Bobrov
on 16 Oct 2014
 Accepted Answer

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);

  0 Comments

Sign in to comment.


Answer by Rainer on 16 Oct 2014

I don't see the two columns and I don't understand what a and b are.

  1 Comment

SS
on 16 Oct 2014
sorry..i corrected it:
  • a =102 sec
  • a =135
  • a =157
  • b =189
  • b =201
  • a =222
  • a =245
  • b =290

Sign in to comment.