compare and save data

2 次查看（过去 30 天）
Lalit Patil
Lalit Patil 2012-11-6
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..

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

采纳的回答

Pedro Villena
Pedro Villena 2012-11-6
编辑：Pedro Villena 2012-11-6
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.');

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by