MATLAB: Comparison of two Vektors with different size to find variables

findvector

I have a problem with my read measurement datas.
A vector has a not quite continuous time series of 15 minutes values ​​for a period of 7 years. The second vector or matrix has a continuous (precipitation) time series of 15 minutes values. I have already tried a few things, but I can not come up with a solution to get a vector with the precipitation values ​​corresponding to the "correct" date from the first vector.
An example of my problem:
a = [731947,312500000
731947,322916667
731947,333333333
731947,364583333
731947,375000000
731947,395833333
731947,406250000]
b = [731947,312500000 2
731947,322916667 5
731947,333333333 6
731947,343750000 8
731947,354166667 2
731947,364583333 0
731947,375000000 0
731947,385416667 0
731947,395833333 0
731947,406250000 0]
c= [731947,312500000 2 %This should be the result.
731947,322916667 5
731947,333333333 6
731947,364583333 0
731947,375000000 0
731947,395833333 0
731947,406250000 0]

Best Answer

E.g.,
x = ismember(b(:,1:2),a(:,1:2),'rows');
c = b(x,:);
Depending on how the times were constructed, you might need to use ismembertol( ).