replacing NaN with zeros in a cell column of strings

Question

antonet 2013-4-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/73462-replacing-nan-with-zeros-in-a-cell-column-of-strings

编辑： Shane Hagen 2015-3-22

Dear all,

I have this column

 A={[NaN]
    [NaN]
    [NaN]
    [NaN]
    [NaN]
 'ka'
[NaN]
    [NaN]
'jdfksjkg'
'ldsiu'
[NaN]
    [NaN]
'jdfkkg'
'jdfkkg'

};

and I want to replace the NaN with zeros that is ,

 A={[0]
    [0]
    [0]
    [0]
    [0]
 'ka'
[0]
    [0]
'jdfksjkg'
'ldsiu'
[0]
    [0]
'jdfkkg'
'jdfkkg'

};

Is there a way of doing that in matlab?

Thanks in advance

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Jan 2013-4-25

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/73462-replacing-nan-with-zeros-in-a-cell-column-of-strings#answer_83426

Are the NaNs the only non-CHAR elements? Then:

A(~cellfun('isclass', A, 'char')) = {0};

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

antonet 2013-4-25

thanks Jan. I have columns of dimension 200000 by 1. so I want to avoid using loops

请先登录，再进行评论。

Answer 2

Wayne King 2013-4-24

4
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/73462-replacing-nan-with-zeros-in-a-cell-column-of-strings#answer_83394

One way is just with a for loop:

for ii = 1:length(A) 
   if isnan(A{ii})
     A{ii} = 0; 
   end
end

4 个评论
显示 2更早的评论隐藏 2更早的评论

Jan 2013-4-25

This is the most simplest method. +1

Shane Hagen 2015-3-22

编辑：Shane Hagen 2015-3-22

isnan doesnt work for cells...can anyone help?

If i separate out the individual cell with NaN it works but not in the loop

ix=cellfun(@isempty,spiketimes);

spiketimes(ix)={0} ; %which I wish would just put 0's

for ii = 1:length(spiketimes)

if isnan(spiketimes{ii})

spiketimes{ii} = 0;

end end

results = spiketimes{j};

%n = length(results(j,:));

plot([results{:} ; results{:}], [ones(1,n)*j-1;ones(1,n)*j],'k-'); end; end;

Undefined function 'isnan' for input arguments of type 'cell'.

this is at the end of my code..would appreciate any help

请先登录，再进行评论。

Answer 3

Cedric 2013-4-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/73462-replacing-nan-with-zeros-in-a-cell-column-of-strings#answer_83412

编辑：Cedric 2013-4-25

You can go for something like:

A(cellfun(@(x)all(x~=x), A)) = {0} ;

but it is just "cosmetic" (in some sense) and the loop proposed by Wayne (with a little update so it manages well non-scalar content) is likely to be more efficient.

2 个评论
显示无隐藏无

antonet 2013-4-25

Any other sugestion?

thanks

Jan 2013-4-25

@antonet: You got two working solutions. Asking for more solutions without explaining, why you are not satisfied already, is not efficient. Please do not let us guess, what you are exactly looking for, because this wastes your and our time.

请先登录，再进行评论。