Info

This question is closed. Reopen it to edit or answer.

Removing duplicate observations in a Matrix where the rows are not completely identical

1 view (last 30 days)

Show older comments

wesso Dadoyan on 6 Jun 2016

0
Link

Direct link to this question

https://ch.mathworks.com/matlabcentral/answers/288043-removing-duplicate-observations-in-a-matrix-where-the-rows-are-not-completely-identical

Closed: MATLAB Answer Bot on 20 Aug 2021

Capture.GIF

Hi,

I have Matrix A, where many rows are like in the attached image. column 1 is the id of the company and column 2 is the date of the data. How can I remove row 2,which is a duplicate of row 1 but row one has more complete data. The matrix is full with these rows that belong to the same company on the same date. Any help is greatly appreciated.

0 Comments
Show -2 older commentsHide -2 older comments

This question is closed.

Answers (1)

KSSV on 7 Jun 2016

0
Link

Direct link to this answer

https://ch.mathworks.com/matlabcentral/answers/288043-removing-duplicate-observations-in-a-matrix-where-the-rows-are-not-completely-identical#answer_224682

doc unique. http://in.mathworks.com/help/matlab/ref/unique.html

2 Comments
Show NoneHide None

wesso Dadoyan on 7 Jun 2016

the two rows are not completely identical.Always one of them has more information

KSSV on 7 Jun 2016

so you fix....any one number (may be the first column), get the indices and remove them.

This question is closed.

Tags

Community Treasure Hunt

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