Find numeric columns in a cell array

Hi,

I would like to use gplotmatrix on a dataset data, which contains mixed data (numeric and strings). However, gplotmatrix works on numeric data, so I need to convert my dataset to a matrix. As far as I understand, the only way is to do this is by

C=dataset2cell(data)
X=cell2mat(C)

However, the second command doesn't work, because C contains non-numeric columns. Is there a way to find which columns of a cell array contains only numbers? Thanks a lot,

Sergio

Answer 1

[Jos (10584)]

% C is a cell array, like
C = {1 2 3 4 5 ; 11 '12' 13:15 14 []}
q = cellfun(@(x) isnumeric(x) && numel(x)==1, C)   % true for elements of C that are numerical scalars
IsAllNum = all(q,1)   % true for columns of C that have only numerical scalars
X = cell2mat(C(:,IsAllNum))   % select and convert

[Bilirubin]

Does anyone know why isnan gives an error msg?

C = {1 2 3 4 5 ; 11 '12' 13:15 14 []}
q = cellfun(@(x) isnan(x) && numel(x)==1, C)   % true for elements of C that are numerical scalars

Answer 2

[Pascal]

If you know whole columns are either numeric or not,

cell2mat(C(:,find(cellfun(@isnumeric, C(1,:)))))