remove nan from table with string and numeric type

1 次查看（过去 30 天）
sensation
sensation 2017-6-12
评论： sensation 2017-6-12
Hi,
I have data as cell data type like:
'HRD_0085' [ 190.7900]
'HRD_0086' [ 11.6500]
'WAT_0087' [ NaN]
etc.
I was trying to apply formula like below in order to get rid of all rows with nan but it doesnt work:
out = C(any(cellfun(@(x)any(~isnan(x)),C),2),:);
Any clue?
Thanks a lot

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2017-6-12
C = {
'HRD_0085' [ 190.7900]
'HRD_0086' [ 11.6500]
'WAT_0087' [ NaN]
};
C(~cellfun(@isnan,C(:,2)),:)

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by