How do I convert a cell array with string, double, and NaN values to a double array

Question

0 个投票

I have a cell with these values = {1, 2, 'None', 1, 2, 3, 5, NaN, 'None'}

I want to convert this into a double with these values = {1, 2, NaN, 1, 2, 3, 5, NaN, NaN}

Is this possible?

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

Answer 1

jonas 2018-9-5

编辑：jonas 2018-9-5

0 个投票

My original solution was obviously flawed, so credits to Guillaume for cleaning up redundant functions

A(strcmp(A, 'None')) = {NaN};
cell2mat(A)

... and credits to Stephen Cobeldick for providing the general solution (for any string):

A(~cellfun(@isnumeric,A)) = {NaN}

Stephen23 2018-9-5

编辑：Stephen23 2018-9-5

No need to use find, logical indexing works perfectly.

An alternative that replaces all non-numeric values:

A(~cellfun(@isnumeric,A)) = {NaN}

jonas 2018-9-5

Thanks guys! I put your solutions in the answer box for future reference, as the answer had already been accepted.