Effacer les filtres
Effacer les filtres

Cumulative sum of cell array column

4 vues (au cours des 30 derniers jours)
Sherwin
Sherwin le 26 Oct 2016
Commenté : Sherwin le 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]

Réponses (2)

Sophie
Sophie le 26 Oct 2016
Modifié(e) : Sophie le 26 Oct 2016
Try this
res=sum(cellfun(@double,A(:,7)))
or
res=cumsum(cellfun(@double,A(:,7)))
  1 commentaire
Sherwin
Sherwin le 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)?

Connectez-vous pour commenter.


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

Connectez-vous pour commenter.

Community Treasure Hunt

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

Start Hunting!

Translated by