How to merge two arries with different elements?

Question

Shenjie Zhou 2016-9-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/303182-how-to-merge-two-arries-with-different-elements

编辑： Adam 2016-9-15

I am working on two series of observational data. Both of them are acquired at the same location at the same time only with two different sensors. Now due to the unstable observational environment, both of them would have some temporary failure in acquiring data. Now I would like to merge the observation data of these two sensors by time, so I could fill in the data blank over the whole observation period.

For example, the functional time of sensor one is [0,1,2,3,4,6,7,8,11,15,23] (hour of the day), while the sensor two are functional at [2,3,4,5,7,9,10,12,13,14,16,18,20,22]; How should I merge these two time record as one, with several commands?

the expectation on the merged array is [0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,18,20,22,23];

I realize the algorithm is simple, but I would like to have some related function in matlab that I can apply on this issue.

Thanks in advance!

Jason

4 个评论
显示 2更早的评论隐藏 2更早的评论

Adam 2016-9-15

Also what happens if neither sensor picked up a reading at a given time?

Shenjie Zhou 2016-9-15

Fill up the time record, but put the corresponding readings as NaN.

请先登录，再进行评论。

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

Answer 1

Adam 2016-9-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/303182-how-to-merge-two-arries-with-different-elements#answer_234894

编辑：Adam 2016-9-15

在 MATLAB Online 中打开

t1 = [0,1,2,3,4,6,7,8,11,15,23];
r1 = rand( 1, 11 );
t2 = [2,3,4,5,7,9,10,12,13,14,16,18,20,22];
r2 = rand( 1, 14 ) * 100;
rNew = NaN( 2, 24 );
rNew( 1, t1 + 1 ) = r1;
rNew( 2, t2 + 1 ) = r2;
rNew = nanmean( rNew );

should do the job, obviously with your real data values instead of the random data I used.

You can also use

rNew = mean( rNew, 'omitnan' );

if you prefer.

Obviously the time array you can just create as:

tNew = 0:23;

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

Shenjie Zhou 2016-9-15

That is brilliant, thanks a lot!

请先登录，再进行评论。

Answer 2

Steven Lord 2016-9-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/303182-how-to-merge-two-arries-with-different-elements#answer_234889

If you're using the new timetable datatype introduced in release R2016b to store your data, take a look at the synchronize function. If not, use interp1 to interpolate both signals to a common time basis.

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

Shenjie Zhou 2016-9-15

Hi Steven,

Interpolation is also a solution, but one of the sensor has missed records more than the other one, so the interpolation on this sensor readings may introduce some error. I am trying to keep the observational data as original as possible.

Thank you for you comment!

请先登录，再进行评论。