suppose i have two dataset p and q and need to compare?? but how if its in excel file ??
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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
Respuestas (2)
Image Analyst
el 24 de Mayo de 2015
To compare floating point numbers, you need to use a tolerance. See the FAQ for code examples:
3 comentarios
Walter Roberson
el 24 de Mayo de 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
el 25 de Mayo de 2015
If p and q are integers, then there's no problem. The problem is only for floating point numbers.
Walter Roberson
el 24 de Mayo de 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 comentarios
Ver también
Categorías
Más información sobre Logical en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!