Find unique rows in a cell array with mixed data types
显示 更早的评论
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,
采纳的回答
dpb
2018-4-30
>> 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
>>
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Characters and Strings 的更多信息
Translated by 
