Merging tables of dissimilar rows in MATLAB.

Question

DEYIRE UMAR 2018-8-27

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/416374-merging-tables-of-dissimilar-rows-in-matlab

编辑： jonas 2018-8-27

My program runs in parallel using parfeval to generate two tables of data. one from a sensor and the other from a robot (UR5). I want to merge these two tables together. The common column is the Time, although there are little differences in their times as they run at different speeds and that makes the rows unequal too. But I want a table containing all the other variables from rows which times are equal or very close. So at the end, there will be only one column for Time. Find photos of sample results attached. Can I get a help?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

jonas 2018-8-27

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/416374-merging-tables-of-dissimilar-rows-in-matlab#answer_334259

编辑：jonas 2018-8-27

You can do the following steps:

Create proper timetables for all variables (use datetime format)
resample using retime to get the same time-slots (optional)
synchronize time-series

If I remember correctly, synchronize will pad the shorter arrays with NaN's.

Please provide actual data (not images) if you need help with the code.

9 个评论
显示 7更早的评论隐藏 7更早的评论

jonas 2018-8-27

编辑：jonas 2018-8-27

在 MATLAB Online 中打开

You are not using the correct terminology, which is confusing. datetime refers to a specific MATLAB format. What you are using is not datetime but the outdated method where dates are represented by doubles. You cannot represent a duration with datetime. For this you need to use duration, which is also a specific format in MATLAB. Try this code instead:

% Read data
sensor = readtable('sensordata.csv');
robot = readtable('robotData.csv');
% Build two timetables 
TT1 = timetable(milliseconds(sensor{:,1}),sensor{:,2:end});
TT2 = timetable(milliseconds(robot{:,1}),robot{:,2:end});
TT1 = splitvars(TT1); 
TT2 = splitvars(TT2);
% specify the time-step you want in the final table,
% it is here set to 10 miliseconds
dt = milliseconds(10);
% Compile final table
TT = synchronize(TT1,TT2,'regular','linear','TimeStep',dt)

Note the important step when the time is converted from a number (double) to a time duration. It is done using the function milliseconds(). Here's an example:

milliseconds(11)

ans =

duration
   0.011 sec

Finally, I understand you started with actual clock format HH:MM:SS.FFF. It would be much more convenient to start from this format, instead of first converting to milliseconds.

DEYIRE UMAR 2018-8-27

I really need this. the variable names are needed other than ' var'

jonas 2018-8-27

编辑：jonas 2018-8-27

在 MATLAB Online 中打开

@Sean de Wolski: Thanks, that works!

@DEYIRE: That's easy. Just write your desired names in a cell array like this:

TT.Properties.VariableNames={'A','B','C','D','E','F','G','H','I','J'}

The cell array must have the same number of cells as the number of table columns (excluding the column with time), and you can only use names that also function as variables, i.e. A-Z and underscore _.

Please copy and paste the code from the previous comment one more time to your script. I made a small but important change.

Finally, please accept if the answer was helpful :)

请先登录，再进行评论。

Answer 2

DEYIRE UMAR 2018-8-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/416374-merging-tables-of-dissimilar-rows-in-matlab#answer_334263

I got it now. I merged and removed NaN but the rows I have are too little because only rows with same Time were picked. I used this code:

Log_table = outerjoin(tcp_coordinates,forces,'MergeKeys', true); Log_table = Log_table(~any(ismissing(Log_table),2),:); writetable(Log_table,'AllData.csv','Delimiter',',')

Now am asked to make it a table with not only same row values of Time but also close values so that it becomes much. I don't know if this is possible? but it doesn't look easy.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Merging tables of dissimilar rows in MATLAB.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

9 个评论
显示 7更早的评论隐藏 7更早的评论

更多回答（1 个）

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

另请参阅

类别

标签

Community Treasure Hunt

Merging tables of dissimilar rows in MATLAB.

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

9 个评论 显示 7更早的评论隐藏 7更早的评论

更多回答（1 个）

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

另请参阅

类别

标签

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

9 个评论
显示 7更早的评论隐藏 7更早的评论

0 个评论
显示 -2更早的评论隐藏 -2更早的评论