select data from table according to date and time

9 次查看（过去 30 天）

显示更早的评论

MOMO JOJO 2019-3-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/452602-select-data-from-table-according-to-date-and-time

评论： Peter Perkins 2022-3-2

Hallo,

I need your help for matlab.

I have a table with dates and times data for 7 days. I want to select records between 14:00 to 16:00 for each day?!

Thanks

2 个评论
显示无隐藏无

Walter Roberson 2019-3-26

Are the times in a separate variable in the table, or do you have a single datetime column?

If the times are in a separate variable in the table, then what format are they in?

MOMO JOJO 2019-3-27

Dear Walter,

The times are in the same table. Some of data are mentionned bellow. They are for 7 days

'08-Feb-2019 11:03:40'

'08-Feb-2019 11:08:40'

'08-Feb-2019 11:13:40'

'08-Feb-2019 11:18:40'

Thanks

请先登录，再进行评论。

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

回答（1 个）

Akira Agata 2019-3-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/452602-select-data-from-table-according-to-date-and-time#answer_367615

在 MATLAB Online 中打开

How about the following way?

% Create sample data
Time = sort(datetime(2019,3,24) + days(7)*rand(1000,1));
Data = rand(1000,1);
T1 = table(Time,Data);
% Select records (row index) between 14:00 to 16:00
idx = (T1.Time.Hour >= 14) & (T1.Time.Hour) < 16;
% Extract selected records
T2 = T1(idx,:);