suppose i have two dataset p and q and need to compare?? but how if its in excel file ??

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

[Walter Roberson]

http://www.mathworks.com/matlabcentral/answers/29922-why-your-question-is-not-urgent-or-an-emergency

Answer 1

[Image Analyst]

To compare floating point numbers, you need to use a tolerance. See the FAQ for code examples:

http://matlab.wikia.com/wiki/FAQ#Why_is_0.3_-_0.2_-_0.1_.28or_similar.29_not_equal_to_zero.3F

[wasima tammi]

thanks but i didnt understand the answer properly..!

[Walter Roberson]

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]

If p and q are integers, then there's no problem. The problem is only for floating point numbers.

Answer 2

[Walter Roberson]

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