Find unique rows in a cell array with mixed data types

3 次查看（过去 30 天）
ZigzS
ZigzS 2018-4-30
评论： ZigzS 2018-5-1
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
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by