filtering a table with dates

Question

AA 2015-9-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/244976-filtering-a-table-with-dates

评论： Walter Roberson 2015-9-27

I have a table with 3 columns. COLUMN one has a serial date number. Column two has the time and column three has a value. I want to filter the table so that I got only serial date numbers in the range of 23. September 2015, 3 pm to 24. September 2015, 5 pm, 3. june 2014, 4 pm to 5. June 2014, 7 pm.

thanks for your help

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2015-9-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/244976-filtering-a-table-with-dates#answer_193678

编辑：Walter Roberson 2015-9-27

在 MATLAB Online 中打开

datelimstr = {'23. September 2015, 3 pm', '24. September 2015, 5 pm', '3. june 2014, 4 pm', '5. June 2014, 7 pm'};
datelim = datenum(datelimstr, 'DD mmmm YYYY, HH PM');
SD = YourTable.SerialDate;
inrange = (SD >= datelim(1) & SD <= datelim(2)) | (SD >= datelim(3) & SD <= datelim(4));
SubTable = YourTable(inrange,:);

This presumes that the "serial date number" includes the time in it and not just the integer part. If not then we need to know what the format is for the time column.

2 个评论
显示无隐藏无

AA 2015-9-27

it doesnt work, i get a table with zeros. can you redefine the code without the time column. i deleted the time column. i only need the date. thanks

Walter Roberson 2015-9-27

在 MATLAB Online 中打开

I had a typo, but otherwise it should have worked, provided the date strings were in the format you posted, complete with commas and period. Anyhow, without the time information:

datelimstr = {'23. September 2015', '24. September 2015', '3. june 2014', '5. June 2014'};
datelim = datenum(datelimstr, 'DD. mmmm YYYY');
SD = YourTable.SerialDate;
inrange = (SD >= datelim(1) & SD <= datelim(2)) | (SD >= datelim(3) & SD <= datelim(4));
SubTable = YourTable(inrange,:);