How to find a list of dates from a timetable?
8 次查看(过去 30 天)
显示 更早的评论
Hi!
I have a long timetable (Date_Captured.mat, attched) that contains 28805 different dates.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1296985/image.png)
....
....
....
I want to find out specific 764 dates (Date_to_find.mat, attched) from the timetable.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1296990/image.png)
....
....
....
Can anyone please tell me how can I do that?
0 个评论
采纳的回答
Star Strider
2023-2-15
Try this —
LD1 = load(websave('Date_Captured','https://www.mathworks.com/matlabcentral/answers/uploaded_files/1296975/Date_Captured.mat'));
Date_Captured = LD1.Date_Captured
LD2 = load(websave('Date_to_find','https://www.mathworks.com/matlabcentral/answers/uploaded_files/1296980/Date_to_find.mat'));
Date_to_find = LD2.Date_to_find
[yc,mc,dc] = ymd(Date_Captured.TimeSeries);
[yf,mf,df] = ymd(Date_to_find.Time);
Lv = ismember([yc,mc,dc],[yf,mf,df],'rows');
Hits = nnz(Lv)
Result = Date_Captured(Lv,:)
.
更多回答(2 个)
Sulaymon Eshkabilov
2023-2-15
An alternative solution:
D1 = load('Date_Captured.mat').Date_Captured;
D2 = load('Date_to_find.mat').Date_to_find;
D2_Date = datetime(D2.Time, 'Format','dd-MMM-uuuu');
DIF_DATES = intersect(D1.TimeSeries, D2_Date);
DALL = D1.TimeSeries(DIF_DATES) % All selected dates
DS_DATA = D1(DIF_DATES, :) % All selected data w.r.t the selected dates
numel(DS_DATA(:,1)) % Number of selected data points/pairs
Seth Furman
2023-3-14
You can index into a timetable more concisely by simply passing the target row-times as row indices.
Load data
load(websave('Date_Captured','https://www.mathworks.com/matlabcentral/answers/uploaded_files/1296975/Date_Captured.mat'));
load(websave('Date_to_find','https://www.mathworks.com/matlabcentral/answers/uploaded_files/1296980/Date_to_find.mat'));
Shift all row-times to the start of the current date
(This step is unnecessary if you already know that your datetimes have zeroes for hours, minutes, seconds, etc.)
Date_Captured.Properties.RowTimes = dateshift(Date_Captured.Properties.RowTimes,"start","day","current");
Date_to_find.Properties.RowTimes = dateshift(Date_to_find.Properties.RowTimes,"start","day","current");
Index the timetable by the target row-times
Date_Captured(Date_to_find.Properties.RowTimes,:)
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Line Plots 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!