필터 지우기
필터 지우기

Merge data by date

조회 수: 3 (최근 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.
Thanks

채택된 답변

Walter Roberson
Walter Roberson 2020년 12월 2일
Convert your data to a timetable() object, and use retime() to consolidate the information.

추가 답변 (1개)

Sindar
Sindar 2020년 12월 2일
Check out groupsummary, specifically this example and this input argument

카테고리

Help CenterFile Exchange에서 Tables에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by