How to extract the months from a datetime table?
12 Ansichten (letzte 30 Tage)
Ashfaq Ahmed am 27 Feb. 2023
I have a series of dates like this -
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.
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.
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")