Clear Filters
Clear Filters

Having data on yearly basis but want to have it on monthly basis

1 view (last 30 days)
so my issue is that I have for one variable data available on a yearly basis - meaning for each year t I have one value. For another variable the data is available on a monthly basis.
How can I get the yearly data on a monthly level meaning that I have a vector which contains for the 1st 12 elements the value of the first year, for the elements 13-24 the value for the second year and so one...
Thanks in adavance.

Answers (2)

Simon Chan
Simon Chan on 21 Jan 2023
Read about function retime

Star Strider
Star Strider on 21 Jan 2023
This is not the correct approach. Interpolating yearly data to monthly data creates data where none previously existed. Once the monthly data are lost they cannot be recovered, unless the original monthly data were saved separately. The comparison will not be correct. If they were, use the original monthly data.
If the original monthly data are not available, do the reverse instead, and use retime to aggregate the monthly data to yearly data. The result of that comparison will then at least be reliable.


Find more on Preprocessing Data 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!