How to merge two arries with different elements?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Adam
le 15 Sep 2016
Modifié(e) : Adam
le 15 Sep 2016
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;
Plus de réponses (1)
Steven Lord
le 15 Sep 2016
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.
Voir également
Catégories
En savoir plus sur Get Started with MATLAB 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!