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
0 个评论
采纳的回答
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 个评论
Peter Perkins
2021-11-23
It's also possible to avoid horzcat and array2table by assigning directly into tTable, as shown here:
dpb
2021-11-23
Good point, Peter...I just took the expedient route. The concatenation is probably measurably slower.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!