How can I know if the repeated numbers of array A appear in B , and if so count their repetition (for A and B ) and divide their countings? A and B have different dimensions.

Question

ANA DIAS 2021-3-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/770953-how-can-i-know-if-the-repeated-numbers-of-array-a-appear-in-b-and-if-so-count-their-repetition-fo

评论： ANA DIAS 2021-3-16

I have two files, and I want to count for both files how many times the values are repeated in a certain column. And if the repeated values appear in both files (for instance: value 0.5 appears repeated in file A and also in file B) I want their counting to be divided.

Example: in file A, column 1 I have 230 number "2" , 430 number "3"....etc

in file B, column 1 I have 500 number "2" , 620 number "3"....etc

After that I need to divide 230 by 430.

500 by 620....and so on.

That's what I did so far:

A = load('fileA.csv');

B = load('fileB.csv');

a = A(:,1);

b = B(:,1);

[count_a,mag_a]=hist(a,unique(a))

[count_b,mag_b]=hist(b,unique(b))

So, in mag_a I have a list of numbers, and in count_a how many times these numbers appear repeated. Same for mag_b and count_b.

I don't know how to tell the program something like: If number "x" is repeated in A and also in B, count and divide the counting.

Thank you!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Athul Prakash 2021-3-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/770953-how-can-i-know-if-the-repeated-numbers-of-array-a-appear-in-b-and-if-so-count-their-repetition-fo#answer_647883

在 MATLAB Online 中打开

Hi Ana,

You may extract the common elements of the array using intersect() function.

common = intersect(mag_a, mag_b);

Then you may create an array of common counts:

countCommon_A = zeros(length(common),1);
countCommon_B = zeros(length(common),1);
for i=1:length(common)
    idx = find(mag_a == common(i));
    countCommon_A = count_a(idx);
    countCommon_B = count_b(idx);
end