I'm trying to create a date columm vector that only has the month and year, since my data are average montly values over a large number of years. I can't seem to find a way to do this when days are not included. Suggestions?

Question

Thomas Burbey 2018-2-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/381946-i-m-trying-to-create-a-date-columm-vector-that-only-has-the-month-and-year-since-my-data-are-averag

评论： Peter Perkins 2018-2-12

I want to create a table column that has month and year (eg. Jan-1991, Feb-1991....Dec-2015) as a date-time type. However, I can't seem to figure out how to do this without incorporating days. My data are monthly average values so I don't need days. Any suggestions on how to do this?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Star Strider 2018-2-10

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/381946-i-m-trying-to-create-a-date-columm-vector-that-only-has-the-month-and-year-since-my-data-are-averag#answer_304502

在 MATLAB Online 中打开

Try this:

Yr = reshape(repmat((1991:2015), 12, 1), [],1);
Mo = repmat(1:12, 1, numel(Yr)/12)';
Da = 1;
t = datetime(Yr,Mo,Da, 'Format','MMM-yyyy');

3 个评论
显示 1更早的评论隐藏 1更早的评论

Star Strider 2018-2-10

My pleasure!

If my Answer helped you solve your problem, please Accept it!

Peter Perkins 2018-2-12

在 MATLAB Online 中打开

Thomas, SS is correct, but just to be clear what's going on: that code creates a datetime vector whose format displays only the year and month, and for most purposes (including probably yours) that's fine. But it's actually creating the sequence 1-Jan-1991, 1-Feb-1991, and only showing you what you care about.

Also, another way to construct that datetime might be to use "rollover":

d = datetime(1991,1:(25*12),1,'Format','MMM-yyyy')

请先登录，再进行评论。