Unique (partial) values
6 views (last 30 days)
Show older comments
Hi all! I have a cell array (imported by xlsread) of this kind:
'0.000000000' '185.47.162.26'
'0.000658000' '185.47.169.249'
'0.000793000' '177.10.146.49'
'0.003146000' '185.47.162.26'
'0.006683000' '185.47.162.26'
Now...i'm interested to select only rows corresponding to the first unique values of second column. So...in this example i need the following output:
'0.000000000' '185.47.162.26'
'0.000658000' '185.47.169.249'
'0.000793000' '177.10.146.49'
Unique function seems not to support a feature like this. Can you help me? Thx in advance! Mario
0 Comments
Answers (1)
Walter Roberson
on 30 Sep 2017
[~, idx] = unique(YourCellArray(:,2), 'stable');
output = YourCellArray(idx, :);
See Also
Categories
Find more on Files and Folders 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!