How to retrieve specific rows that the coordinates x,y have been saved in another matrix?

Question

Sara Salimi 2016-11-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/310180-how-to-retrieve-specific-rows-that-the-coordinates-x-y-have-been-saved-in-another-matrix

评论： Guillaume 2016-11-1

Hi,

I have a data matrix Data(8765x138) that first and second columns are x and y coordinates. I have sampled some specific points in another array, Points(2000x2), first and second columns in A refers to x and y, respectively. I want to extract some specific rows in Matlab that match with matrix A (both x,y). The output should be (2000x138). I tried the following code but the result is not correct.

      newData = Data(ismember(Data(:,1),Points(:,1))& ismember(Data(:,2),Points(:,2)),:);

what should I do to select the rows from Data that its first and second columns match to my Points matrix. Someone please help, I feel like I've tried everything!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Guillaume 2016-11-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/310180-how-to-retrieve-specific-rows-that-the-coordinates-x-y-have-been-saved-in-another-matrix#answer_241597

在 MATLAB Online 中打开

The problem with your statement is that it finds all rows of Data whose x match an x in Points and match any y in Points but not necessarily in the same Points row. To fix this, you need to use the 'row' option of ismember:

newData = Data(ismember(Data(:, [1 2]), Points(:, [1 2]), 'rows'), :)