Cumulative sum of cell array column

4 visualizaciones (últimos 30 días)
Sherwin
Sherwin el 26 de Oct. de 2016
Comentada: Sherwin el 26 de Oct. de 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]

Respuestas (2)

Sophie
Sophie el 26 de Oct. de 2016
Editada: Sophie el 26 de Oct. de 2016
Try this
res=sum(cellfun(@double,A(:,7)))
or
res=cumsum(cellfun(@double,A(:,7)))
  1 comentario
Sherwin
Sherwin el 26 de Oct. de 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)?

Iniciar sesión para comentar.


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

Iniciar sesión para comentar.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by