How can I calculate the cumulative sum of this file?

1 visualizzazione (ultimi 30 giorni)
Hello everyone,
I should calculate the cumulate of the column 4, from 2015 until 2020. How can I do it?
Thank you!

Risposta accettata

Steven Lord
Steven Lord il 1 Dic 2021
"calculate the cumulative" what of the file?
Cumulative sum? cumsum.
Cumulative product? cumprod.
Cumulative minimum or maximum? cummin and cummax.
  5 Commenti
Steven Lord
Steven Lord il 2 Dic 2021
Can you show:
whos DATIECMWFgiornalieri
I'm assuming the comma inside the cumsum call is a typo, as otherwise that code would have thrown an error.
If I'm right and DATIECMWFgiornalieri is a table or timetable array, extract the contents of the fourth variable using curly braces instead of extracting the fourth variable as a sub-table using parentheses.
load patients
T = table(LastName, Height, Weight, Age);
head(T) % Show only the first few rows
ans = 8×4 table
LastName Height Weight Age ____________ ______ ______ ___ {'Smith' } 71 176 38 {'Johnson' } 69 163 43 {'Williams'} 64 131 38 {'Jones' } 67 133 40 {'Brown' } 64 119 49 {'Davis' } 68 142 46 {'Miller' } 64 142 33 {'Wilson' } 68 180 40
C1 = cumsum(T{:, 4}) % Cumulative sum of the Age variable
C1 = 100×1
38 81 119 159 208 254 287 327 355 386
C2 = cumsum(T(:, 4)) % Will error as cumsum is not defined for table arrays
Error using cumsum
Invalid data type. First input argument must be numeric or logical.
Pul
Pul il 2 Dic 2021
Modificato: Pul il 2 Dic 2021
Yes, got it, thank you.

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Loops and Conditional Statements in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by