How can I calculate the cumulative sum of this file?

Hello everyone,

I should calculate the cumulate of the column 4, from 2015 until 2020. How can I do it?

Thank you!

Answer 1

[Steven Lord]

"calculate the cumulative" what of the file?

Cumulative sum? cumsum.

Cumulative product? cumprod.

Cumulative minimum or maximum? cummin and cummax.

[Pul]

Cumulative sum."

It gives me this error:"Invalid data type. First input argument must be numeric or logical."

[Steven Lord]

What is the class of the variable that you're passing into cumsum? If it is named T, for example, what does this command display?

whos T

Can you also show the exact call to cumsum that you executed that results in that error message?

[Pul]

Cumulative=cumsum(DATIECMWFgiornalieri,(:,4));

[Steven Lord]

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]

Yes, got it, thank you.