remove not corresponding values in matrix

7 views (last 30 days)
M.Ven
M.Ven on 17 Nov 2017
Commented: M.Ven on 21 Nov 2017
There are 2 matrices, matrix (1) of the dimensions 1374200x18 and matrix (2) larger one with 200000x2. Matrix (1) is a discontinue matrix with in column 1 the time vector. Matrix (2) is a continuous time vector and air pressure. Now i want obtain a vector with only with values of time corresponding to Matrix (1). Is this possible?
  1 Comment
M.Ven
M.Ven on 17 Nov 2017
Edited: M.Ven on 17 Nov 2017
My question is not really clear. I want to compare the first column of matrix (1) to column of matrix (2) and remove, for the not corresponding value, the entire row of matrix (2).

Sign in to comment.

Accepted Answer

KL
KL on 17 Nov 2017
Edited: KL on 17 Nov 2017
first create some dummy data,
mat1 = [1:10;rand(1,10)].'; % matrix with continuous values on column 1
mat2 = [randperm(20,10);rand(1,10)].'; %column 1 with discontinuities
now use ismemeber,
res = mat2(ismember(mat2(:,1),mat1(:,1)),:) %get the data of mat2 where its col1 matches with mat1's column 1.
if you want to remove the other values from mat2,
mat2(~ismember(mat2(:,1),mat1(:,1)),:) = [];

More Answers (0)

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!