Indexing a timetable using time
显示 更早的评论
Dear
I have a timetable in a range of many days in seconds, see figure below. I need to indexing this timetable in a range of hour and minutes for all range of dates. To do that i used this code:
Dates_ind = Universo_MidPrice.DateTime >=datetime('10:00:00.000',"Format","HH:mm:ss.SSS") & Universo_MidPrice.DateTime < datetime('16:50:00.000',"Format","HH:mm:ss.SSS");
After that, I will use this logical vector to indexing the timetable. This did not work. The problem is the absence of date in the datetime function once this code works if you include only a range of dates. However, the aim is indexing all dates in the range of hours and minutes. Any help will be appreciate.
采纳的回答
DateTime = (datetime('2022-02-12') : minutes(30) : datetime('2022-02-18')).';
Universo_MidPrice = table(DateTime, randn(size(DateTime)), randn(size(DateTime)), randn(size(DateTime)))
[G,ID] = findgroups(hour(Universo_MidPrice.DateTime), minute(Universo_MidPrice.DateTime)) % Index By 'hour' & 'minute'
Check = unique(G)
OutTest_1 = Universo_MidPrice(G==2,:)
OutTest_2 = Universo_MidPrice(G==10,:)
There are 289 rows in ‘Universo_MidPrice’ and 48 unique values for the grouping index ‘G’ and the output tests ‘OutTest’ demonstrate the indexing result.
.
2 个评论
Victor Oliveira
2022-2-13
Star Strider
2022-2-13
As always, my pleasure!
I also thought about this a bit more and came up with an easier way to determine a specific group.
For example, to get the group at 12:30, this would work —
[G,IDH,IDM] = findgroups(hour(Universo_MidPrice.DateTime), minute(Universo_MidPrice.DateTime)); % Index By 'hour' & 'minute'
Gfun = @(Hq,Mq,IDH,IDM) G((Hq == IDH) & (Mq == IDM)); % Group Index Function
Gq = Gfun(12,30,IDH,IDM); % Call Function
OutTest_3 = Universo_MidPrice(G==Gq,:) % Retrieve Data
OutTest_3 =
6×4 table
DateTime Var2 Var3 Var4
____________________ ________ ________ _______
12-Feb-2022 12:30:00 -0.62213 -0.54984 -0.407
13-Feb-2022 12:30:00 -0.96357 -0.34282 1.9107
14-Feb-2022 12:30:00 -0.47125 0.11991 0.91968
15-Feb-2022 12:30:00 0.5523 -0.89608 0.42213
16-Feb-2022 12:30:00 -0.51851 1.8942 0.11464
17-Feb-2022 12:30:00 -0.86003 0.55424 1.3727
This might make the table a bit easier to work with.
.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
