How to find all unique Names in a Matrix
28 views (last 30 days)
Show older comments
Hello,
I am trying to find all the unique names (Stocks Symbols) contained in the following 7500x7 Cell Matrix. Any suggestion on how to achieve the aimed result? The function ...
unique(Symbol)
does not seem to work.
Thank you
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/148951/image.jpeg)
0 Comments
Accepted Answer
Stephen23
on 11 Apr 2015
Edited: Stephen23
on 22 May 2015
>> A = {NaN,'cath','doug';NaN,'anna',NaN;NaN,'bob','eva';NaN,'anna','cath'}
A =
[NaN] 'cath' 'doug'
[NaN] 'anna' [ NaN]
[NaN] 'bob' 'eva'
[NaN] 'anna' 'cath'
>> unique(A(cellfun('isclass',A,'char')))
ans =
'anna'
'bob'
'cath'
'doug'
'eva'
This simply excludes any non-character values from the unique call, and is faster than calling an anonymous function as the first argument for cellfun:
>> temp(10000)
Elapsed time is 3.403746 seconds.
Elapsed time is 0.096025 seconds.
The timing file is attached here:
0 Comments
More Answers (3)
Image Analyst
on 10 Apr 2015
This seems to work:
% Create 2 by 3 cell array with 3 unique strings and NaNs.
ca = {nan, 'AAA', 'AAB'; nan, 'AC', 'AAA'}
ca2 = ca(:, 2:3); % Extract columns 2 & 3
% Find the 3 unique strings in columns 2 and 3
uniqueNames = unique(ca2)
What did you do differently?
0 Comments
Jon
on 10 Apr 2015
I think the problem is the NaNs. If you don't remove them, as Image Analyst does when defining ca2, the unique function seems to fail. If it's possible for NaN to be dispersed throughout the data, you'll need to exclude them from the unique command. The following might work for you.
UniSyms=unique(Symbol(cellfun(@(x) all(~isnan(x)),Symbol)));
0 Comments
See Also
Categories
Find more on Logical 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!