Cumulative sum of cell array column
Afficher commentaires plus anciens
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)
Try this
res=sum(cellfun(@double,A(:,7)))
or
res=cumsum(cellfun(@double,A(:,7)))
1 commentaire
Sherwin
le 26 Oct 2016
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.
Catégories
En savoir plus sur Numbers and Precision dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!