MATLAB: Merging tables of dissimilar rows in MATLAB.

MATLABmatlab function

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?

Best Answer

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.

Related Solutions

MATLAB: How to import Datetime Format form Database (Microsoft Access)

Change the date in MATLAB, once it is imported using the datetime and readtable command.

% Code for reading the date from the input file
>> T = readtable('<filename>','Delimiter', '|');
>> T.Var3 = datetime(T.Var3,'InputFormat','yyyy-MM-dd HH:mm:ss.SSSSSSSSS','Format','dd/MMM/yyy HH:mm:ss.SSS');

Use the input format specifier to specify the format of the date strings.

Reference:

https://in.mathworks.com/help/matlab/ref/datetime.html

https://in.mathworks.com/help/matlab/ref/readtable.html

MATLAB: Add timetable with many months to another timetable with few months

Look at synchronize it does exactly this:

tt = timetable(dateshift(datetime,'start','day'), 42, 'VariableNames',"Cars")
tt2 = timetable([dateshift(datetime,'start','day');datetime], [42;17], 'VariableNames',"Buses")
synchronize(tt,tt2,"intersection")

And if you want to play with this kind of thing interactively, in 19b, which shipped yesterday, you can use the join tables "Live Task".

Best Answer

Related Solutions

MATLAB: How to import Datetime Format form Database (Microsoft Access)

MATLAB: Add timetable with many months to another timetable with few months

Related Question