How do I convert monthly data to quarterly using as the value of the quarter the value of the 1st month of each quarter?
36 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (2)
Cris LaPierre
il 14 Dic 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 Commenti
Vedere anche
Categorie
Scopri di più su Preprocessing Data in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!