- 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 (최근 30일)
이전 댓글 표시
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
채택된 답변
jonas
2018년 8월 27일
편집: jonas
2018년 8월 27일
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
jonas
2018년 8월 27일
편집: jonas
2018년 8월 27일
@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 :)
추가 답변 (1개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Timetables에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!