Merge data by date

5 ビュー (過去 30 日間)
Ricardo López
Ricardo López 2020 年 12 月 1 日
回答済み: Walter Roberson 2020 年 12 月 2 日
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.


Walter Roberson
Walter Roberson 2020 年 12 月 2 日
Convert your data to a timetable() object, and use retime() to consolidate the information.

その他の回答 (1 件)

Sindar 2020 年 12 月 2 日
Check out groupsummary, specifically this example and this input argument


Community Treasure Hunt

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

Start Hunting!

Translated by