Removing NaN from cell array

2012 6 28
1 个回答
回答已采纳
25 次查看（30 天）

0 个投票

I have cell array which ends with NaN as last row
'Mat Name' 'MAT Type' 'E1'
'GFRP' 'GFRP' 'GFRP'
'CFRP' 'CFRP' 'CFRP'
'KFRP' 'KFRP' 'KFRP'
'SCDB' 'SCDB' 'SCDB'
'ABCD' 'ABCD' 'ABCD'
[NaN] [NaN] [ NaN]
How to remove the NaN from the last row of cell array
thanks in advance

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

 采纳的回答

Honglei Chen
Honglei Chen 2012-6-28
编辑：Honglei Chen 2012-6-28

4 个投票

x = {'xy','yz',nan}
x(cellfun(@(x) any(isnan(x)),x)) = []

8 个评论
显示 6更早的评论 隐藏 6更早的评论

Hello Thanks for your response i tried this command but the following error occurred
raw(cellfun(@isnan,raw)) = [] ??? Error using ==> cellfun Non-scalar in Uniform output, at index 1, output 1. Set 'UniformOutput' to false.
Ryan
Ryan 2012-6-28
try:
x(cellfun(@isnan,x,'UniformOutput',false))
Honglei Chen
Honglei Chen 2012-6-28
I've updated the answer
Its works for the array x which you shown but for the cell array
'Mat Name' 'MAT Type' 'E1'
'GFRP' 'GFRP' 'GFRP'
'CFRP' 'CFRP' 'CFRP'
'KFRP' 'KFRP' 'KFRP'
'SCDB' 'SCDB' 'SCDB'
'ABCD' 'ABCD' 'ABCD'
[NaN] [NaN] [ NaN]
its is not working, kindly help
Honglei Chen
Honglei Chen 2012-6-28
Add
reshape(x,[],3)
after you run the command in my answer
!!wonderfull!! wow its work well, what is the logic behind it
Honglei Chen
Honglei Chen 2012-6-28
cellfun will loop each cell for you to check whether a cell is nan or not, but it does not preserve the dimension. So you need to reshape it back at the end.
Jan
Jan 2012-6-28
Another approach, which remove all non-strings: x = x(cellfun('isclass', x, 'char'))

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Matrix Operations and Transformations 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by