Input timetables must contain unique row times when synchronizing using 'linear'
30 次查看(过去 30 天)
显示 更早的评论
I tried running the below code but I'm shown an error something like this,
Input timetables must contain unique row times when synchronizing using 'linear'
T.Time = days(T.Time);
T.Time.Format = "hh:mm:ss.SSS";
TT = table2timetable(T,'RowTimes','Time');
head(TT);
D = readtable('DIC.xlsx');
D.Time = days(D.Time);
D.Time.Format = "hh:mm:ss.SSS";
DD = table2timetable(D,'RowTimes','Time');
data = synchronize(TT,DD,"secondly","linear");
I also tried to use Live Editor --> Task button ---> synchronous Timetable and I'm not able to find "interpolation" in the scroll down.
Please share your suggestions.
Thanks,
0 个评论
回答(1 个)
Peter Perkins
2022-3-2
The problem is that one of these files has duplicate rows:
>> t1 = readtable('ctm.xlsx');
>> t1.Time = days(t1.Time); t1.Time.Format = "hh:mm:ss.SSS";
>> tt1 = table2timetable(t1);
>> t2 = readtable('DIC.xlsx');
>> t2.Time = days(t2.Time); t2.Time.Format = "hh:mm:ss.SSS";
>> tt2 = table2timetable(t2);
>> tt1(tt1.Time == 0,:)
ans =
2×1 timetable
Time Deflection
____________ __________
00:00:00.000 0
00:00:00.000 0.034
>> tt1(tt1.Time == "00:09:02.700",:)
ans =
4×1 timetable
Time Deflection
____________ __________
00:09:02.700 2.712
00:09:02.700 2.712
00:09:02.700 2.712
00:09:02.700 2.712
This would be easy to clean up by hand, but in general, the way to remove exact duplicate rows would be retime. But it's not clear what to do with those first two rows that have different Deflection values. Let's say, take the sum:
>> tt1u = retime(tt1,unique(tt1.Time),"sum")
tt1u =
11825×1 timetable
Time Deflection
____________ __________
00:00:00.000 0.034
00:00:00.200 0.034
00:00:00.400 0.034
00:00:00.600 0.034
00:00:00.900 0.034
[snip]
And then this works:
>> data = synchronize(tt1u,tt2,"secondly","linear")
data =
2673×2 timetable
Time Deflection Outofplane
____________ __________________ ___________________
00:00:00.000 0.034 0
00:00:01.000 0.034 -0.0304169823710666
00:00:02.000 0.034 -0.0597900517877678
00:00:03.000 0.036 -0.0387827506926043
00:00:04.000 0.039 -0.0184773732647037
[snip]
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Timetables 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!