Remove duplicate on rows
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I'm working with nominative patent data from french applicants. So my file contains the name of the patent applicants. Each row is a patent, and each contains the name of one of the patent applicants. But there are duplicate. I would like to clean each row of the duplicate names (since each row is a patent and the names are in column). ![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1118890/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1118890/image.png)
Does anybody have an idea ?
0 commentaires
Réponses (1)
Ergin Sezgin
le 7 Sep 2022
Hello Heman,
Try using unique function which returns only the unique elements in the array.
newData = unique(yourData);
If you want the process to be non-case sensitive, for example if there are two elements 'Adam Smith' and 'adam smith', you can use lower function, and then unique function.
[~, idx] = (unique(lower(yourData)));
newData = yourData(idx)
I hope it helps.
0 commentaires
Voir également
Catégories
En savoir plus sur Building and Simulating Electronic, Mechatronic, and Electrical Power System Networks dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!