试用软件

Count numbers of identical rows

36 次查看（过去 30 天）

显示更早的评论

Panayiotis Christodoulou 2016-5-4

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/282561-count-numbers-of-identical-rows

评论： Star Strider 2016-5-4

采纳的回答： Star Strider

在 MATLAB Online 中打开

Hi there,

I am a new member here.

I have a sample dataset:

I want the measure how many times does an identical row appears.

so the final result should be :

I have done it with a for loop but because my dataset is 8million x 2 if taking a lot of time and I am looking for an alternative solution.

Thanks

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

Star Strider 2016-5-4

Panayiotis Christodoulou’s ‘Answer’ moved here:

there was an error on how the data were represented

please see atatched image

请先登录，再进行评论。

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

采纳的回答

Star Strider 2016-5-4

4
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/282561-count-numbers-of-identical-rows#answer_220800

在 MATLAB Online 中打开

This works:

M = [3 5
    3 5
    5 6
    5 6
    5 6
    5 7 
    6 8];
[Mu,ia,ic] = unique(M, 'rows', 'stable');           % Unique Values By Row, Retaining Original Order
h = accumarray(ic, 1);                              % Count Occurrences
maph = h(ic);                                       % Map Occurrences To ‘ic’ Values
Result = [M, maph]
Result =
       3     5     2
       3     5     2
       5     6     3
       5     6     3
       5     6     3
       5     7     1
       6     8     1

2 个评论
显示无隐藏无

Panayiotis Christodoulou 2016-5-4

thanks for your help!

100% working

Star Strider 2016-5-4

My pleasure!

请先登录，再进行评论。

更多回答（0 个）

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

类别

MATLAB Language Fundamentals Matrices and Arrays Creating and Concatenating Matrices

在 Help Center 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

标签

Community Treasure Hunt

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

Translated by

试用软件