Finding similar elements in a single matrix

4 次查看(过去 30 天)
I have one matrix,
x = [
2 0 0
3 3 0
4 4 0
5 5 5
6 6 6]
How can I find the common elements between columns in the matrix and count them? for example, here 3 and 4 repeated two times.
  4 个评论
Walter Roberson
Walter Roberson 2022-12-2
So you just need to know the total number of non-zero elements? You can use nnz for that.
Md. Nazrul Islam Siddique
That's easy. what about the non zero elements between two metrices?

请先登录,再进行评论。

采纳的回答

Star Strider
Star Strider 2022-12-2
One approach using accumarray
x = [2 0 0
3 3 0
4 4 0
5 5 5
6 6 6];
[Aunique,~,idx] = unique(x(:));
Counts = accumarray(idx, 1);
Result = table(Aunique, Counts)
Result = 6×2 table
Aunique Counts _______ ______ 0 4 2 1 3 2 4 2 5 3 6 3
.
  9 个评论
Md. Nazrul Islam Siddique
I want to know the total number which is repeated. For example, 1 and 2 repeated two times, 5 repeated three times. Other numbers are repeated only one. The total count is: 12.
Star Strider
Star Strider 2022-12-2
Just sum the ‘Count’ results —
x = [1 2 3
4 5 6];
y = [1 5 7
2 5 8];
xy = [x; y]
xy = 4×3
1 2 3 4 5 6 1 5 7 2 5 8
xy = xy(xy~=0);
[XYunique,~,idx] = unique(xy(:));
Counts = accumarray(idx, 1);
Result = table(XYunique, Counts)
Result = 8×2 table
XYunique Counts ________ ______ 1 2 2 2 3 1 4 1 5 3 6 1 7 1 8 1
TotalCounts = sum(Counts)
TotalCounts = 12
If the matrices are not conformable to concatenation (they are conformable here), then reshape both to be column vectors using the column vector operator ‘(:)’ and then vertically concatenate those. Then use unique and accumarray.
.

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Preprocessing Data 的更多信息

产品


版本

R2022b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by