MATLAB Answers

Cumulative sum of cell array column

15 views (last 30 days)
Sherwin
Sherwin on 26 Oct 2016
Commented: Sherwin on 26 Oct 2016
Hi
I have this cell array and I need to get the cumulative sum of column 7. Please help.
A =
Columns 1 through 3
{1x39 cell} {1x75 cell} [ 7.669142585357160e-04]
{1x75 cell} {1x75 cell} [-1.206232786783515e-04]
{1x39 cell} {1x41 cell} [ 8.630787019556518e-04]
{1x41 cell} {1x65 cell} [-2.445883525841570e-05]
{1x65 cell} {1x97 cell} [ 9.109657363289406e-04]
Columns 4 through 6
[-1.206232786783515e-04] [3.231454899286823e-04] [150]
[ 0.001808452047926] [8.439143846238298e-04] [-40]
[-2.445883525841570e-05] [4.193099333486180e-04] [170]
[ 9.109657363289406e-04] [4.432534505352624e-04] [-20]
[-6.645138877833179e-04] [1.232259242728113e-04] [180]
Columns 7 through 11
[ -40] [ 55] [1x1 sym] [1x1 sym] [1x1 sym]
[ 330] [145] [1x1 sym] [1x1 sym] [1x1 sym]
[ -20] [ 75] [1x1 sym] [1x1 sym] [1x1 sym]
[ 180] [ 80] [1x1 sym] [1x1 sym] [1x1 sym]
[-140] [ 20] [1x1 sym] [1x1 sym] [1x1 sym]

Answers (2)

Sophie
Sophie on 26 Oct 2016
Edited: Sophie on 26 Oct 2016
Try this
res=sum(cellfun(@double,A(:,7)))
or
res=cumsum(cellfun(@double,A(:,7)))
  1 Comment
Sherwin
Sherwin on 26 Oct 2016
Thank you so much, would you please help me to put this column vector in the first column of a S = cell(5,2)?

Sign in to comment.


James Tursa
James Tursa on 26 Oct 2016
Edited: James Tursa on 26 Oct 2016
result = cumsum(vertcat(A{:,7}));
or
result = sum(vertcat(A{:,7}));
depending on what you want.
  2 Comments
Sherwin
Sherwin on 26 Oct 2016
Would you please help me to put this column vector in the first column of a S = cell(5,2)?

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by