How to synchronize two different timetable (Each has a different time format)
3 次查看(过去 30 天)
显示 更早的评论
How to add dates to an already created timetable?
Timeline = xlsread('Timeline.xlsx');
Lidar_DeltaT = Timeline(2, 1);
GPS_DeltaT = Timeline(3, 1);
Lidar_Distance= readtimetable('Lidar Cycle.txt');
summary(Lidar_Distance);
Lidar_Distance.Time = Lidar_Distance.Time + seconds(Lidar_DeltaT);
GPS_Velocity = readtimetable('GPS cycle 1.txt');
summary(GPS_Velocity)
GPS_Velocity.Time = GPS_Velocity.Time + seconds(GPS_DeltaT);
TT_Sync = synchronize(Lidar_Distance, GPS_Velocity, 'Uniform');
with it,
Lidar_Distance timetable look like this :
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/350477/image.jpeg)
And GPS_Velocity timetable look like this :
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/350480/image.jpeg)
I want to synchronize two time tables. But It fails every time because of time format difference.
I don't know how to settle this two timetables into one timetable.
And I also want to set the reference time format of the two timetables to GPS. This is because the GPS time interval is tighter. After that, I want to make two timetables into one, and treat the missing data in the Lidar_Distance timetable as a value of '0'.
(This is because the GPS_Velocity data is consistently recorded in units of 1 second, while the Lidar_Distance data sometimes skips 2 seconds.)
采纳的回答
Cris LaPierre
2020-8-23
编辑:Cris LaPierre
2020-8-23
Did you see the answer I provided in your previous post? It contains a solution for this. For Lidar Cycle.txt, read in the date as a datetime, the time of day as a duration, and add date and time together.
At the end of my code, I uses synchronize to combine the two timetables, and the plot velocity and distance vs time using yyases..
更多回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!