How to easily detect all the equal rows of an array with saving the indices of the elements?

1 view (last 30 days)
I have a matrix as shown here
A=[ -1 0 0;
-1 0 0;
-1 0 0;
-1 0 0;
1 0 0;
1 0 0;
] I want to detect all the equal rows in the matrix and build another matrix with the indices of the equal rows. For exemple here row1=rows2=row3=row4 and row5=row6... I want to have a matrix like this [1 2;1 3;1 4; 5 6]. I find a solution but it uses a lot of for loops so it's not fast enough when I apply it to a large matrix. Is there any easiest solution for this. Thank you.

Answers (1)

Ahmet Cecen
Ahmet Cecen on 19 May 2016
This does all of that:
[C,ia,ic] = unique(A,'rows')
  2 Comments
Sleh Eddine Brika
Sleh Eddine Brika on 19 May 2016
Thank you Ahmet, I had already tried this function, but its outputs requires additional treatments to get the result that I want. For my exemple, we get ia =[1;5] ic = [1 ;1;1;1;2;2 ] so we need to count for each element of ic how many times it's repeated and then create another matrix that take the first element of ia in column1 and according to the number of repetition in ic (let's say n) affect index for ia(1)+1 to n for the column2. It's a solution but I am working with matrices with more then 2000 rows so it's not fast enough.

Sign in to comment.

Categories

Find more on Resizing and Reshaping Matrices in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!