How can i create a loop to generate daily averages from a csv. file for over four years and whose data was input at a 15minutes interval?
6 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
the data looks like this
0 commentaires
Réponse acceptée
Cris LaPierre
le 1 Sep 2022
Modifié(e) : Cris LaPierre
le 1 Sep 2022
Use groupsummary and group the data by 'monthofyear' and 'dayofmonth' and the method set to mean. See this answer:
Here is a simple example
Date = [datetime(2016,6,4)+calyears(0:5)';datetime(2016,6,5)+calyears(0:5)'];
X = rand(size(Date));
Y = rand(size(Date));
Z = rand(size(Date));
tbl = table(Date,X,Y,Z)
out = groupsummary(tbl,["Date","Date"],["monthofyear","dayofmonth"],'mean')
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets 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!