remove nan from table with string and numeric type

2017 6 12
1 个回答
回答已采纳
更新时间：2017 6 12
4 次查看（30 天）

0 个投票

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

0 个投票

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

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 NaNs 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by