Duplicate names in one cell column
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi,
I have a cell that contain several columns among them one text column (e.g., Person names). How can I check that the there is no duplicate names inside this column (If there is a duplicate names just assign duplicateName=true).
Thanks
0 commentaires
Réponses (2)
Yatin
le 15 Oct 2013
Hi,
You can use the " hist " functions and the unique functions to determine if there are any duplicate values in your columns. Below is a sample code snippet:
arr = [5 3 1 5 6];
u = unique(arr);
n = hist(arr, u);
result = arr(n > 1);
Hope this helps.
0 commentaires
Jan
le 15 Oct 2013
Modifié(e) : Jan
le 16 Oct 2013
duplicateName = (numel(unique(C(:, index))) == size(C, 1))
[EDITED: Parenthesis fixed]
2 commentaires
Jan
le 16 Oct 2013
In your question you wrote:
I have a cell that contain several columns among them one text column
Then index is the index of the column, which contains the text. If C is this column already, use:
numel(unique(C)) == size(C, 1)
Voir également
Catégories
En savoir plus sur Matrix Indexing 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!