How to create “Date” containers in Matlab, ignoring months and years?

2 次查看（过去 30 天）
John
John 2017-1-23
评论： John 2017-1-24
My goal is to extract specific rows from a table (see below) that fall into specific "date" containers, e.g. month-end ( 25th-31st, regardless of the month and year). Date range from Jan-2005 until Aug-2016 and time-step is "weekly".
So far I only managed to create binaries for rows that fall into a specific date period:
% T.Date=[datetime(T.Date, 'InputFormat', 'eee dd-MMM-yyyy')];
% Define date containers
tlower = datetime(2016,07,25);
tupper = datetime(2016,07,31);
% Return ones if date falls in between tlower and tupper
Binary = isbetween(T.Date,tlower,tupper)
% If "Binary" returns 1, use this row and stack it into a new table
% with same headers as table "T". -> How?
How can I create date containers that ignore months and years, returning all rows in a new table that are "month-end" ( 25th-31st of each month) ?

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

采纳的回答

Guillaume
Guillaume 2017-1-23
编辑：Guillaume 2017-1-23
Learn to manipulate datetime objects:
Either use the day member function:
filteredtable = T(day(T.Date) > 25, :)
or directly the Day property of datetime:
filteredtable = T(T.Date.Day > 25, :)

更多回答（2 个）

the cyclist
the cyclist 2017-1-23
编辑：the cyclist 2017-1-23
Here is one way
% Parameters
DAY_COL = 3;
DAY_THRESHOLD = 25;
% Set up some pretend data
Date = {'5-Aug-2016'; '29-Jul-2016'};
x1 = [0.03; 0.0095];
T = table(Date,x1);
% Extract the components of the date
dv = datevec(T.Date);
% Identify the end of the month days
isEndOfMonth = dv(:,DAY_COL) >= DAY_THRESHOLD;
% Filter to just those days
T_end = T(isEndOfMonth,:);
If you have the Financial Toolbox, then you could use the day command to simplify this. I had to resort to using the datevec command, because I don't have that toolbox.
The details of how you do it may also depend on the format your Date variable inside the table.
  3 个评论
显示 1更早的评论
the cyclist
the cyclist 2017-1-23
I did not realize day was part of base MATLAB now. Old habits die hard. (Also, the first hit on google search found the toolbox version!)
Also, I somehow completely overlooked the code that showed that the Table variable was a datetime object. Time for more coffee, I guess.

请先登录，再进行评论。

Peter Perkins
Peter Perkins 2017-1-23
In addition to Guillaume's answer, there's also this:
>> d = datetime('now')
d =
datetime
23-Jan-2017 14:09:32
>> week(d,'weekofmonth')
ans =
4
John, you've defined "month-end" as "the last seven days of a month". It sounds like that's what you intend, but there might be more complicated ways to define it, for example, "the last calendar week of the month, even if that's partial". So you could compare week(d,'weekofmonth') to this:
>> dEnd = dateshift(d,'end','month') % last day of the month
dEnd =
datetime
31-Jan-2017 00:00:00
>> week(dEnd,'weekofmonth') % number of calendar weeks in this month
ans =
5

类别

在 Help Center 和 File Exchange 中查找有关 Calendar 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by