How to complile data with two different time steps

Question

krai 2018-6-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/404477-how-to-complile-data-with-two-different-time-steps

评论： krai 2018-6-7

I have a data set like,

time1- 0.0 0.2 0.4 0.6 , exp1 - 110 123 126 128, time2 - 0.1 0.2 0.3 0.4 0.5 0.6, exp2 - 569 587 598 562 698 587

now I want to compile the data to a single sheet with same time step as shown below time 0.2 0.4 0.6, exp1 123 126 128, exp2 587 562 587. how can this be done? thanks in advance..

2 个评论
显示无隐藏无

Walter Roberson 2018-6-7

Could you confirm that what you have is a file or character vector that has exactly one line similar to 'time1- 0.0 0.2 0.4 0.6 , exp1 - 110 123 126 128, time2 - 0.1 0.2 0.3 0.4 0.5 0.6, exp2 - 569 587 598 562 698 587' ?

Or are there multiple lines? Or are there multiple columns each with a header?

krai 2018-6-7

These are multiple columns each with a header (time1, exp1, time2, exp2)

请先登录，再进行评论。

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

Answer 1

Akira Agata 2018-6-7

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/404477-how-to-complile-data-with-two-different-time-steps#answer_323601

在 MATLAB Online 中打开

Like this?

% Arrange your data to tables
time1 = [0.0 0.2 0.4 0.6]';
exp1 = [110 123 126 128]';
time2 = [0.1 0.2 0.3 0.4 0.5 0.6]';
exp2 = [569 587 598 562 698 587]';
T1 = table(time1,exp1);
T2 = table(time2,exp2);
% Merge T1 and T2 using innerjoin function
T = innerjoin(T1,T2,'LeftKeys','time1','RightKeys','time2');