Convert cell to double

Question

>> C = [{1} {2} ; {'@CF'} {2}] 
C = 

[  1]    [2]
'@CF'    [2]


>> whos C
  Name      Size            Bytes  Class    Attributes

  C         2x2               478  cell

How can I convert C into double so that:

>> C
C = 
1    2
NaN  2

I've tried str2double(C). It returns:

   NaN   NaN
   NaN   NaN

score 12 · Answer 1 · answered Jul 17 '12 at 15:47

12

C = [{1} {2} ; {'@CF'} {2}]

C = 

    [  1]    [2]
    '@CF'    [2]

D = cellfun(@isnumeric,C);
C(~D)={nan}

C = 

    [  1]    [2]
    [NaN]    [2]

cell2mat(C)

ans =

     1     2
   NaN     2

answered Jul 17 '12 at 15:47

tmpearce

12,523
4
42
60

score 6 · Accepted Answer · answered Jul 17 '12 at 15:51

6

Find the non numeric values with isnumeric, queried by cellfun. Use that with logical indexing to extract the numeric values:

C = [{1} {2} ; {'@CF'} {2}];
isnum = cellfun(@isnumeric,C);
result = NaN(size(C));
result(isnum) = [C{isnum}];

answered Jul 17 '12 at 15:51

Gunther Struyf

11,158
2
34
58

A shorter way to code is, C(cellfun(@ischar, C) = {NaN}; C = cell2mat(C); – user1532230 Jul 18 '12 at 02:24
1

@user1532230: No, it's quite the same. I even suspect `cell2mat` takes more time than my simple array writing and reading code. – Gunther Struyf Jul 18 '12 at 07:21

score 1 · Answer 3 · answered Jul 17 '12 at 15:45

1

Well, you have mixed data types here so there isn't a very straight forward way to do it.

The easiest way I can think of, if you know where the data is you want, is to simply use cell2mat

IE: cell2mat(C(1,1)) would return 1 as a double.

answered Jul 17 '12 at 15:45

Ben A.

1,039
6
13

Convert cell to double

3 Answers3

Linked