Merge data by date
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Ricardo López
le 1 Déc 2020
Réponse apportée : Walter Roberson
le 2 Déc 2020
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
0 commentaires
Réponse acceptée
Walter Roberson
le 2 Déc 2020
Convert your data to a timetable() object, and use retime() to consolidate the information.
0 commentaires
Plus de réponses (1)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!