How to extract the months from a datetime table?
20 ビュー (過去 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!