compare and save data

Question

Lalit Patil 2012-11-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/52911-compare-and-save-data

http://www.fileconvoy.com/dfl.php?id=g645815cb6847f60f1668697c4e61c1bb29e057

In this file first column is r, second is c, fourth is R,fifth is C.. I want to find and save all those R,C which are same as r,c.. R,C are pairs and when matching is to do R,C will be compared to r,c..

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

请先登录，再进行评论。

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

Answer 1

Pedro Villena 2012-11-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/52911-compare-and-save-data#answer_64465

编辑：Pedro Villena 2012-11-6

在 MATLAB Online 中打开

data=xlsread('Book1.xlsx');
r=data(~isnan(data(:,1)),1);
c=data(~isnan(data(:,2)),2);
R=data(~isnan(data(:,4)),4);
C=data(~isnan(data(:,5)),5);
[flag,index] = ismember([r c],[R C],'rows');
RR = R(index(flag));
CC = C(index(flag));
plot(r,c,'r.',R,C,'g.',RR,CC,'b.');