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

2 views (last 30 days)
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 Comments
Ahsan Abbas
Ahsan Abbas on 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 on 30 Mar 2016
Edited: Image Analyst on 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.

Sign in to comment.

Accepted Answer

Jan
Jan on 30 Mar 2016
Edited: Jan on 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, :);

More Answers (0)

Categories

Find more on Multidimensional Arrays 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!