Merge data by date

Good afternoon,

I have a big matrix of an hourly consumption of 5 houses for 2 years. The matrix has two columns: one with date in this format: " 2020-10-05 00:00:00 " and the other column as data.

I would like to order the data based on date. So for " 2020-10-05 00:00:00 " the sum of each house. I tried to do it manually but its a long way and I feel that there is a way to do it with a loop more efficiently.

Thanks

Answer 1

[Walter Roberson]

Convert your data to a timetable() object, and use retime() to consolidate the information.

Answer 2

[Sindar]

Check out groupsummary, specifically this example and this input argument