How do I convert monthly data to quarterly using as the value of the quarter the value of the 1st month of each quarter?
65 views (last 30 days)
Show older comments
Ioannis Leivadiotis on 14 Dec 2020
Answered: Eric Sofen on 14 Dec 2020
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.
Cris LaPierre on 14 Dec 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.
Perhaps this example can help get you started. The code might be something like this
qtrCPI = groupsummary(mnCPI,"Timestamp","quarter","mean")
Eric Sofen on 14 Dec 2020
Find more on Descriptive Statistics in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!