suppose i have two dataset p and q and need to compare?? but how if its in excel file ??
3 views (last 30 days)
Show older comments
i have 2 dataset p and q and i want to compare 1st row all columns of p with each row with all columns of q and want to count that number which it matches??
but how?
i have written the following code buy it doesnt show the resuts properly....
count=0;
for i=1:size(p,1)
for j=1:size(q,1)
if all(p(i,:)==q(j,:))
count=count + 1;
end
end
end
can anyone plz help as its urgent..:D..thanks in advance
Answers (2)
Image Analyst
on 24 May 2015
To compare floating point numbers, you need to use a tolerance. See the FAQ for code examples:
3 Comments
Walter Roberson
on 24 May 2015
Instead of having all(p(i,:)==q(j,:)) instead have tolerance = 0.000001;
if all( abs(p(i,:)-q(j,:)) < tolerance )
here you should adjust tolerance for your situation.
Image Analyst
on 25 May 2015
If p and q are integers, then there's no problem. The problem is only for floating point numbers.
Walter Roberson
on 24 May 2015
In the case where you do not need to worry about floating point round-off (such as if you are using integral values), then
counts = zeros(size(p),1));
for K = 1:size(p,1)
counts(K) = sum( ismember(q, p(K,:), 'rows') );
end
This would give a per-row count. You can then sum(counts) to get the total number of matches. (Note that identical rows in p would get counted multiple times in that sum.)
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!