- Create proper timetables for all variables (use datetime format)
- resample using retime to get the same time-slots (optional)
- synchronize time-series
Merging tables of dissimilar rows in MATLAB.
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
jonas
le 27 Août 2018
Modifié(e) : jonas
le 27 Août 2018
You can do the following steps:
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 commentaires
jonas
le 27 Août 2018
Modifié(e) : jonas
le 27 Août 2018
@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 :)
Plus de réponses (1)
Voir également
Catégories
En savoir plus sur Data Type Identification dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!