how to concatenate two tables into one such that the timestamps of two tables are in sequence and the corresponding values are arranged according to their timestamps

Question

Padmamalini T H 2020-3-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/509171-how-to-concatenate-two-tables-into-one-such-that-the-timestamps-of-two-tables-are-in-sequence-and-th

评论： amir-nejati 2023-4-22

i have two tables with engine data such that in the first table the first column contains timestamp and second column contains speed data, in the second table the first column is a timestamp and the second column is gear data. i want to make these two tables to one such that the first column contains timestamps of both tables arranged in a sequence and then the second and third column contains their corresponding speed and gear values respectively.

i used code such as t = [t1 t2];

but this does not arrange them in a sequence.

also i dont know how to write the speed and gear values corresponding to their timestamps.

can someone help me with this problem please

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

J. Alex Lee 2020-3-5

在 MATLAB Online 中打开

when you say "table" do you mean, in terms of matlab data types, an actual table? or are you actually using matlab arrays?

class(t1)
class(t2)

Are your timestamps the same in both sets of data such that you have both gear and speed data at the same times? If this is not the case, what do you expect to fill in the missing data?

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Guillaume 2020-3-5

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/509171-how-to-concatenate-two-tables-into-one-such-that-the-timestamps-of-two-tables-are-in-sequence-and-th#answer_418692

在 MATLAB Online 中打开

It should be very easy. Convert your tables to timetables (if they're not already) then call synchronize:

speedtimetable = table2timetable(yourspeedtable);
geartimetable = table2timetable(yourgeartable);
speedandgear = synchronize(speedtimetable, geartimetable);

in theory. If this doesn't work then attach a mat file with your two tables.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

amir-nejati 2023-4-22

The only issue with this solution is when in one of your table or timetable there are some rows with the same timestamp, in that case the synchronize function will ignore one of the rows,any idea how to solve that problem?

Thanks

请先登录，再进行评论。