how to reshape data with leap year?
1 view (last 30 days)
Show older comments
I have 30 years daily data. For reason, i want to reshape the data as days*years (e.g. 365/366, 30). for the year with no leap day it would be easy (reshape(Data,365,[]). how one would do it with leap day included?. see the code I tried but is not working. the data I have is from 1981-2010.
Data=(1:10957)';
R=reshape(Data,[],30); % of course it wont work because of the dimensions
4 Comments
Walter Roberson
on 19 Oct 2017
Then there is the old "all entries with the same calendar date must appear in the same row", in which case you get NaN in the middle for each Feb 29 that is not present.
Accepted Answer
KL
on 19 Oct 2017
Edited: KL
on 19 Oct 2017
No need to reshape. Use timetables.
then you can simply use
yearlymeantable = retime(yourtimetable,'yearly','mean')
3 Comments
Walter Roberson
on 19 Oct 2017
No, it is producing an average for each year. It has to pick a representative date from each year to associate the average with, because MATLAB does not have a time object that has "year only". If you want just the year to show up, you could use
TT2.t1.Format = 'yyyy';
More Answers (0)
See Also
Categories
Find more on Calendar 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!