Thread Subject: cellfun and cell2mat

I have a code that is supposed to apply the function
cell2mat to a matrix called funds (monthly return of funds)
from excel.

when I do cell2mat (funds) I receive:
??? Error using ==> cell2mat at 47
All contents of the input cell array must be of the same
data type.

and at 47 it is:
Error out if cell array contains mixed data types

cellclass = class(c{1});
ciscellclass = cellfun('isclass',c,cellclass);
~all(ciscellclass(:)) and I got ans=1 for this.

if I do class (funds)the answer is = cell. And if I do
class (funds (1,1)), or any other position the ans is cell.

the matrix is a 107x2, with the 1,1 and 1,2 positions being
the names of the 2 funds, and the rest being the returns.

How can I get the error for cell2mat, and how can the
answer for cellfun be subclass, and not class if class
(funds) for all the positions is cell??

How can I fix it???

"bruna mari" <bruna.mari@forsythpartners.com> wrote in message
<g13ecu$d43$1@fred.mathworks.com>...
> I have a code that is supposed to apply the function
> cell2mat to a matrix called funds (monthly return of funds)
> from excel.
>
> when I do cell2mat (funds) I receive:
> ??? Error using ==> cell2mat at 47
> All contents of the input cell array must be of the same
> data type.
>
> and at 47 it is:
> Error out if cell array contains mixed data types
>
> cellclass = class(c{1});
> ciscellclass = cellfun('isclass',c,cellclass);
> ~all(ciscellclass(:)) and I got ans=1 for this.
>
> if I do class (funds)the answer is = cell. And if I do
> class (funds (1,1)), or any other position the ans is cell.
>
> the matrix is a 107x2, with the 1,1 and 1,2 positions being
> the names of the 2 funds, and the rest being the returns.
>
> How can I get the error for cell2mat, and how can the
> answer for cellfun be subclass, and not class if class
> (funds) for all the positions is cell??
>
> How can I fix it???

But if there are two cells that are strings,
and the rest of the cells are numeric data,
then you CANNOT form this cell array
into a numeric array. The error message
clearly states this fact.

Double arrays CANNOT hold mixed types
of data. This is why we have cell arrays.

If you strip off the string elements from
your cell array and only apply cell2mat
to the purely numeric part which remains,
then it will work.

HTH,
John

> if I do class (funds)the answer is = cell. And if I do
> class (funds (1,1)), or any other position the ans is cell.

class(funds{i,j})

Try this for all of your cells and I think you'll find your
answer. You found that the class of each element is a cell,
but you did not test for what class the contents of each
cell is, and that's where you are getting the error.

Ken

"Ken Fleisher" <k-fleisher.donotspamme@nga.gov> wrote in
message <g13muo$4ml$1@fred.mathworks.com>...
> > if I do class (funds)the answer is = cell. And if I do
> > class (funds (1,1)), or any other position the ans is
cell.
>
> class(funds{i,j})
>
> Try this for all of your cells and I think you'll find
your
> answer. You found that the class of each element is a
cell,
> but you did not test for what class the contents of each
> cell is, and that's where you are getting the error.
>
> Ken

Hi,

Thanks!

So I can' t use cell2mat in a matrix with headers
containing chars...

But the code was working before the system changed from XP
to Vista, once I changed the system, even maintaining the
excel 2003 and the Matlab R2007a its not working anymore....

Any ideas of how to transform the matrix in only one type
of data???

"bruna mari" <bruna.mari@forsythpartners.com> wrote in message
<g13pku$774$1@fred.mathworks.com>...
> "Ken Fleisher" <k-fleisher.donotspamme@nga.gov> wrote in
> message <g13muo$4ml$1@fred.mathworks.com>...
> > > if I do class (funds)the answer is = cell. And if I do
> > > class (funds (1,1)), or any other position the ans is
> cell.
> >
> > class(funds{i,j})
> >
> > Try this for all of your cells and I think you'll find
> your
> > answer. You found that the class of each element is a
> cell,
> > but you did not test for what class the contents of each
> > cell is, and that's where you are getting the error.
> >
> > Ken
>
> Hi,
>
> Thanks!
>
> So I can' t use cell2mat in a matrix with headers
> containing chars...
>
> But the code was working before the system changed from XP
> to Vista, once I changed the system, even maintaining the
> excel 2003 and the Matlab R2007a its not working anymore....
>
> Any ideas of how to transform the matrix in only one type
> of data???

No. I can absolutely assure you that cell2mat
did NOT work previously on a cell array of
this form. Vista versus XP is not relevant.

As I said, drop off the elements that are not
numeric, then apply cell2mat to the remainder.

John