cumulative sum by hour

3 次查看（过去 30 天）
Jonathan Roadley-Battin
回答： Sally Al Khamees 2017-7-13
Good afternoon,
I capture hourly information with regards to usage such that the file appears like:
Name, dd/MM/YY HH:MM, used
ie
jon, 03/07/17 12:00, 1
mark, 03/07/17 12:00, 1
mary, 03/07/17 12:00, 1
jon, 03/07/17 13:00, 1
mary, 03/07/17 13:00, 1
The data is stored in an CSV.
What I would like is to create a cumulative sum per hour
03/07/17 12:00, 3
03/07/17 13:00, 2
two separate fields, timeseries and a summation. The aim is to show usage on a per hour basis (user information is not needed for this. I could brute force an sum on an hourly basis but I am hoping not to resort to an iterative approach.
Is there simpler method to collate such data?

请先登录，再回答此问题。

回答（1 个）

Sally Al Khamees
Sally Al Khamees 2017-7-13
Hi Jonathan,
You can read the file into cell arrays and then, use "find" function to get the indices of yourdesired rows and then, use "sum" function for the sum of entries

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by