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

Question

wasima tammi 2015-5-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/218441-suppose-i-have-two-dataset-p-and-q-and-need-to-compare-but-how-if-its-in-excel-file

评论： Image Analyst 2015-5-25

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Walter Roberson 2015-5-24

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2015-5-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/218441-suppose-i-have-two-dataset-p-and-q-and-need-to-compare-but-how-if-its-in-excel-file#answer_180265

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

3 个评论
显示 1更早的评论隐藏 1更早的评论

Walter Roberson 2015-5-24

在 MATLAB Online 中打开

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 2015-5-25

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

请先登录，再进行评论。

Answer 2

Walter Roberson 2015-5-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/218441-suppose-i-have-two-dataset-p-and-q-and-need-to-compare-but-how-if-its-in-excel-file#answer_180278

在 MATLAB Online 中打开

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