How to extract the months from a datetime table?
15 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Ashfaq Ahmed
am 27 Feb. 2023
Bearbeitet: Ashfaq Ahmed
am 27 Feb. 2023
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 Kommentare
Akzeptierte Antwort
Stephen23
am 27 Feb. 2023
Bearbeitet: Stephen23
am 27 Feb. 2023
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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Dates and Time finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!