How do I convert monthly data to quarterly using as the value of the quarter the value of the 1st month of each quarter?
35 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a dataset of monthly data on CPI and I want to convert it to quarterly. I tried to use timetable but it didn't work I think.
0 commentaires
Réponses (2)
Cris LaPierre
le 14 Déc 2020
Not knowing anything about the format of your data, I would suggest using groupsummary. This will allow you to determine how to summarize the monthly data to quarterly data (average, sum, etc). If your data is already in a table or timetable, and your date info is already a datetime, you can use the 'quarter' groupbin.
qtrCPI = groupsummary(mnCPI,"Timestamp","quarter","mean")
0 commentaires
Voir également
Catégories
En savoir plus sur Preprocessing Data 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!