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

4 次查看（过去 30 天）

Akul Satish 2018-9-5

编辑： Stephen23 2018-9-5

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?

jonas 2018-9-5

编辑：jonas 2018-9-5

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.

MATLAB Language Fundamentals Data Types Numeric Types Logical

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

R2018a

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

Translated by