remove not corresponding values in matrix

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 commentaire

M.Ven
M.Ven le 17 Nov 2017
Modifié(e) : M.Ven le 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).

Connectez-vous pour commenter.

 Réponse acceptée

KL
KL le 17 Nov 2017
Modifié(e) : KL le 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)),:) = [];

Plus de réponses (0)

Produits

Question posée :

le 17 Nov 2017

Commenté :

le 21 Nov 2017

Community Treasure Hunt

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

Start Hunting!

Translated by