creating a look up table to compare datetime stamps
조회 수: 3 (최근 30일)
이전 댓글 표시
Hi
I need to create a look up table, where i would need to specify. This will need to a manual table, where i would need to spicify the following:
Start DateTimeStamp, Stop DateTimeStamp and Device ID.
Then i would like to compare a incoming datastreams timestamp, aganist this lookup table to to NaN samples between the dates.
How can i create a table from Matlab, instead of using spreadsheet and how do you compare timestamps?
댓글 수: 0
채택된 답변
Star Strider
2022년 11월 20일
DateTime = datetime('now')+hours(0:4:150).';
DeviceID = randi(9, size(DateTime));
T1 = table(DateTime,DeviceID)
Start_DateTimeStamp = "21-Nov-2022 12:00";
Stop_DateTimeStamp = "22-Nov-2022 18:00";
Device_ID = randi(9)
Lv = isbetween(T1.DateTime, Start_DateTimeStamp, Stop_DateTimeStamp) & Device_ID==T1.DeviceID;
Query = nnz(Lv)
Result = T1(Lv,:)
Make appropriate changes to work with your data.
.
댓글 수: 10
dpb
2022년 11월 23일
Nothing prevents you from organizing the file structure however it best suits the task...
Again, you've given us absolutely no context with which to work; how are we to have any idea of any specific organization or code structure that would fit?
추가 답변 (1개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Tables에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!