Azzera filtri
Azzera filtri

Cumulative sum of cell array column

4 visualizzazioni (ultimi 30 giorni)
Sherwin
Sherwin il 26 Ott 2016
Commentato: Sherwin il 26 Ott 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]

Risposte (2)

Sophie
Sophie il 26 Ott 2016
Modificato: Sophie il 26 Ott 2016
Try this
res=sum(cellfun(@double,A(:,7)))
or
res=cumsum(cellfun(@double,A(:,7)))
  1 Commento
Sherwin
Sherwin il 26 Ott 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)?

Accedi per commentare.


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

Accedi per commentare.

Community Treasure Hunt

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

Start Hunting!

Translated by