compare and save data

Lalit Patil

2012 11 6

1 个回答

回答已采纳

2 次查看（30 天）

0 个投票

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更早的评论

请先登录，再进行评论。

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

Follow Question

采纳的回答

Pedro Villena 2012-11-6

编辑：Pedro Villena 2012-11-6

在 MATLAB Online 中打开

0 个投票

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.');