MATLAB: Find unique rows in a cell array with mixed data types

cell unique array double string

Hi,
I have a cell array formatted like the following:
    >> stations
    'WOSB'    [    NaN]   [     NaN]
    'YOUB'    [48.8266]   [-121.123]
    ..
It contains a lot of "stations" denoted by a several character string (e.g. 'WOSB'), followed by a latitude and a longitude. A lot of the entries have NaN in the lat/long places as displayed above, and there are a ton of repeats. I want to extract the unique rows of this cell array, but when I try I get the following:
     unique(stations)
     Error using *cell/unique* (line xx)
     Input A must be a cell array of strings.
How can I get the unique rows from this cell array with the mixed types?
Thanks,

Best Answer

>> t=cell2table(stations)
t =
2×3 table
  stations1    stations2    stations3
  _________    _________    _________
  'WOSB'           NaN           NaN 
  'YOUB'       48.8266      -121.123 
>> unique(t,'rows')
ans =
2×3 table
  stations1    stations2    stations3
  _________    _________    _________
  'WOSB'           NaN           NaN 
  'YOUB'       48.8266      -121.123 
>>
Related Question