Finding elements of matrix that match a condition
1 view (last 30 days)
Show older comments
Hello everyone,
I am working with some big data sets and I wanted to find some elements from one matrix that satisfy a condition. So, what I have. Matrix A is 251576x5. Column 1 is a timestamp, columns 2 to 4 are x,y,z coordinates and column 5 is something else that is not important to me. Matrix B is 26300x1 and is a column of timestamps starting from 0 and incrementing by 100. What I want is, for each timestamp on B I want the row with that same, or the closest possible, timestamp from A saved in another Matrix. So my output should be a matrix C, 26300x5 in dimensions.
For example, this is a piece of matrix A
25194.41 313.93 440.32 372.93 274
25727.49 327.04 420.64 387.72 277
A timestamp from matrix B is
25200
So what would be saved here in matrix C should be 25194.41 313.93 440.32 372.93 274.
I hope I made myself clear enough. Thank you all in advance
0 Comments
Answers (1)
Ameer Hamza
on 14 Oct 2020
You can use interp1() with nearest option
Bx = interp1(A(:,1), A(:,2:4), B, 'nearest');
C = [B Bx];
9 Comments
Ameer Hamza
on 14 Oct 2020
Yes. If that happens, then the interpolation will fail. I guess that is the most likely reason for the error you are receiving.
See Also
Categories
Find more on Matrix Indexing in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!