How to get monthly average
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have data (47 * 1)for 26 months starting in 2015 ending in 2107 as the Xlsx file
Some months it has 3 values and some are 2 or1
I want to get average values for each month as new-data(26*1).
Any suggestion, to help me?
0 commentaires
Réponses (1)
dpb
le 15 Oct 2018
t=readtable('month.xlsx');
t=table2timetable(t);
mn=retime(t.Var1,'monthly',@mean);
I didn't download the file so if there are variable names for Var1 use whatever the variable is.
2 commentaires
Voir également
Catégories
En savoir plus sur Get Started with MATLAB 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!