MATLAB: Find numeric columns in a cell array

Question

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 know, the only way is to do this is through

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

However, the second command throws an error, because C contains non-numeric columns. Is there a way to find which columns of a cell array are purely numeric?

It works! I got the cellfun(@isnumeric,C) part working, but I didn't think of postprocessing it with all. Thanks! Any references to learn this stuff? — DeltaIV
– DeltaIV, Commented Jul 3, 2014 at 13:08
Yes, google for "cellfun matlab", "function handle matlab", etc. :) — Divakar
– Divakar, Commented Jul 3, 2014 at 13:11

Divakar · Accepted Answer · 2014-07-03 15:23:04Z

1

Use cellfun with @isnumeric function handle -

numeric_cols = find(all(cellfun(@isnumeric,C)))

Related useful pointers -

answered Jul 3, 2014 at 15:23

Divakar

222k19 gold badges273 silver badges374 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MATLAB: Find numeric columns in a cell array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related