how to compare 2 data files parallel and take data based on matching time?

Question

swathi 2020-1-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/502029-how-to-compare-2-data-files-parallel-and-take-data-based-on-matching-time

回答： woahs 2020-1-26

A file data( it reads the data at every 100ms or 0.1s),it starts the time on 2s and it ends on 6s

time      height     velocity     distance
          23.12    103.12        21.2    
1         23.13    103.15        21.5
2         23.15    103.2           21.52
3         23.25    103.25        21.65
4         23.35    103.36        21.7
5        23.37     103.45        21.75
6        23.45     103.52        22.21
7        23.56     103.58        22.25
8        23.86     103.65        22.56
9        23.95    103.72        22.78
          24        103.78        23
......................................its continious goes on upto 6

B file data (it reads the data at every 1s),it starts on 3s and it ends on 6s

time        height        velocity    distance
          24                103.78        23
          25                104.78        24
          26                105.78        25
          27                105.78        26

based on time match it will take data

it will check A file time to B file time

if any time match is there it reads data

i used ismember function

but i want to write complete code on how to read both files based on time

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

dpb 2020-1-26

Use the timetable object and can merge/interpolate to heart's content.

However, as you've described the desired result, there seems no need for file A; all the data you're interested in is in B and A is simply a subset therefrom it appears.

Surely there's something else going on here...

请先登录，再进行评论。

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

Answer 1

woahs 2020-1-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/502029-how-to-compare-2-data-files-parallel-and-take-data-based-on-matching-time#answer_412094

在 MATLAB Online 中打开

Like dpb said above, it's unclear what the desired output is from the example data you've provided is.

From what I can understand, I assume you want to return just the rows that have a common time value in both sets. In which case, you can use intersect to get the intersection of the two time vectors.

Table_A = array2table(...
    [2            23.12    103.12        21.2;...    
    2.1         23.13    103.15        21.5;...
    2.2         23.15    103.2           21.52;...
    2.3         23.25    103.25        21.65;...
    2.4         23.35    103.36        21.7;...
    2.5        23.37     103.45        21.75;...
    2.6        23.45     103.52        22.21;...
    2.7        23.56     103.58        22.25;...
    2.8        23.86     103.65        22.56;...
    2.9        23.95    103.72        22.78;...
    3            24        103.78        23], ...
    'VariableNames', {'time', 'height', 'velocity', 'distance'});
Table_B = array2table(...
    [3            24                103.78        23;...
    4            25                104.78        24;...
    5            26                105.78        25;...
    6            27                105.78        26], ...
    'VariableNames', {'time', 'height', 'velocity', 'distance'});
Table_C = intersect(Table_A, Table_B)