How to extract the months from a datetime table?
15 次查看(过去 30 天)
显示 更早的评论
Hi!
I have a series of dates like this -
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1308710/image.png)
I want to create 12 variables naming - January, February, March, April,.., December in a way that each of the month contains the index value from the DateStamp for that month.
For example,
1984-05-02 is index 1, and it be assigned under 'May'.
Similarly, 1984-06-03 is index 2, and it be assigned under 'June'. And so on.
I have attached the DateStamp.mat file. Any feedback will be much appreciated! Thank you so much.
0 个评论
采纳的回答
Stephen23
2023-2-27
编辑:Stephen23
2023-2-27
S = load('DateStamp.mat')
T = S.DateStamp;
T.month = T.date;
T.month.Format = 'MMMM'
But I am guessing that your actual goal is to perform some kind on analysis on your data, e.g. the means:
M = categorical(datetime(1,1,1,"Format","MMM")+calmonths(0:11));
T.year = T.date.Year;
T.month = M(T.date.Month).';
S = groupsummary(T,["year","month"],"mean","x_CloudCover");
U = unstack(S,"mean_x_CloudCover","month", "GroupingVariables","year")
4 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!