Add a new column to CSV file with equations

3 次查看(过去 30 天)
I have a large data set
17568 rows x 12 columns in an xslx and csv file (1st row header, the rest numbers, dates, year etc)
I need to create a new column that is the cummulative sum of a column in the data set. If possible that also makes Na values 0.
example:
Year A B
2001 3 2
2001 4 1
I need to make:
Year A B CummA CummB
2001 3 2 3 2
2001 4 1 7 3

采纳的回答

dpb
dpb 2021-11-18
[tTable array2table(cumsum(tTable{:,{'A','B'}}),'VariableNames',{'cumA','cumB'})];
where tTable is your table variable.
One can get fancy and use the table properties property 'VariableNames' to build the name fields dynamically as well.
As for the NaN, there's an optional flag with cumsum to ignore NaN in the calculations if that's the result you wish; it effectively inserts a zero in place of the value by ignoring it in computing the sums--it does NOT replace the NaN in the data itself.
You've got to decide which way you want to go...it's trivial exercise to just replace NaN values with zeros first in the original data, but then, of course, they're gone and if there are zero values that are inherent in the data to begin with, then you've lost the distinction.
  3 个评论
dpb
dpb 2021-11-23
Good point, Peter...I just took the expedient route. The concatenation is probably measurably slower.

请先登录,再进行评论。

更多回答(0 个)

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by