Duplicate names in one cell column
2 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (2 件)
Yatin
2013 年 10 月 15 日
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 件のコメント
Jan
2013 年 10 月 15 日
編集済み: Jan
2013 年 10 月 16 日
duplicateName = (numel(unique(C(:, index))) == size(C, 1))
[EDITED: Parenthesis fixed]
2 件のコメント
Jan
2013 年 10 月 16 日
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)
参考
カテゴリ
Help Center および File Exchange で Logical についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!