Remove the entire row from the matrix on the basis of column having duplicate value

5 visualizzazioni (ultimi 30 giorni)
Hello Guys I have a matrix A that contains duplicate values in row 3,4 from column 3 to 6. I want to remove the entire 4th row, or both rows, how can i do it without using the loop?. what if i have similar problem in more rows, what's the syntax for this? I want to solve it in 1 line, help me to solve the problem. Thanks
  3 Commenti
Ahsan Abbas
Ahsan Abbas il 30 Mar 2016
No it's not, but if we can sort it on the basis of 3rd column then it will be adjacent rows.
Image Analyst
Image Analyst il 30 Mar 2016
Modificato: Image Analyst il 30 Mar 2016
You may have to give up the one line requirement unless you want to just string multiple lines of code together on one line, which you can do. I think you could do that with Jan's 2 line code below.

Accedi per commentare.

Risposta accettata

Jan
Jan il 30 Mar 2016
Modificato: Jan il 30 Mar 2016
This removes all rows of the matrix Data, which have repeated values in the 3rd column. The first occurence is kept:
[C, IA] = unique(Data(:, 3), 'stable');
Data = Data(iA, :);

Più risposte (0)

Categorie

Scopri di più su Shifting and Sorting Matrices in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by