How to convert irregular daily data to annual data?
2 views (last 30 days)
Show older comments
Keegan Carvalho
on 19 Aug 2022
Commented: Keegan Carvalho
on 19 Aug 2022
Hi All!
I have a dataset (excel file attached - pcr.xlsx) of daily data values. The values are expressed as "Tonnes". I wanted to convert these to annual data from 1959 till date. My issue is that the daily data are irregular i.e. each year does not contain 365/366 values, so I am confused on how to directly get the answer (if each year had constant number of data points - 365, I think it would be easier).
I did try the "convert2annual" function but had no luck with it. I would appreciate some help in this regard. Thank you!
0 Comments
Accepted Answer
Chunru
on 19 Aug 2022
Edited: Chunru
on 19 Aug 2022
T = readtable("https://www.mathworks.com/matlabcentral/answers/uploaded_files/1101770/pcr.xlsx");
T(T.Tonnes == 0, :) =[]; % remove rows where Tonnes == 0
head(T)
T1 = timetable(datetime(T.Dates, "InputFormat", 'dd-MM-yyyy'), T.Tonnes);
T1.Properties.VariableNames = "Tonnes";
T2 = retime(T1, 'yearly', 'mean')
3 Comments
More Answers (0)
See Also
Categories
Find more on Data Type Conversion 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!