Prev: solving system of nonlinear equations
Next: How to use NNARX model in simulink
From: Jay WONG on 2 Jul 2010 14:12
I am trying to import large amount of data (mixed with strings and numeric data) from excel files. As my data set has no clear structure, I would like to do a one time import without introducing 'NaN'.

Matlab displays NaN once a non-numeric data is imported.

Is there a way to import once without reading data line-by-line.

thank you,
From: Andy on 2 Jul 2010 14:19
"Jay WONG" <dcba7777(a)hotmail.com> wrote in message <i0la5k$5hb$1(a)fred.mathworks.com>...
> I am trying to import large amount of data (mixed with strings and numeric data) from excel files. As my data set has no clear structure, I would like to do a one time import without introducing 'NaN'.
>
> Matlab displays NaN once a non-numeric data is imported.
>
> Is there a way to import once without reading data line-by-line.
>
> thank you,

Have you tried xlsread?
From: Jay WONG on 2 Jul 2010 14:44
"Andy " <myfakeemailaddress(a)gmail.com> wrote in message <i0laio$20j$1(a)fred.mathworks.com>...
> "Jay WONG" <dcba7777(a)hotmail.com> wrote in message <i0la5k$5hb$1(a)fred.mathworks.com>...
> > I am trying to import large amount of data (mixed with strings and numeric data) from excel files. As my data set has no clear structure, I would like to do a one time import without introducing 'NaN'.
> >
> > Matlab displays NaN once a non-numeric data is imported.
> >
> > Is there a way to import once without reading data line-by-line.
> >
> > thank you,
>
> Have you tried xlsread?


Yes, that messed up the data structure. I want to keep the data structure intact.
xlsread recategorize your data type.
thanks ,
From: Andy on 2 Jul 2010 14:52
"Jay WONG" <dcba7777(a)hotmail.com> wrote in message <i0lc1l$756$1(a)fred.mathworks.com>...
> "Andy " <myfakeemailaddress(a)gmail.com> wrote in message <i0laio$20j$1(a)fred.mathworks.com>...
> > "Jay WONG" <dcba7777(a)hotmail.com> wrote in message <i0la5k$5hb$1(a)fred.mathworks.com>...
> > > I am trying to import large amount of data (mixed with strings and numeric data) from excel files. As my data set has no clear structure, I would like to do a one time import without introducing 'NaN'.
> > >
> > > Matlab displays NaN once a non-numeric data is imported.
> > >
> > > Is there a way to import once without reading data line-by-line.
> > >
> > > thank you,
> >
> > Have you tried xlsread?
>
>
> Yes, that messed up the data structure. I want to keep the data structure intact.
> xlsread recategorize your data type.
> thanks ,

xlsread has an option to return a cell array with mixed text and numeric data. Are you using this syntax? Can you post your code so we can see what's going wrong?
 | 
Pages: 1
Prev: solving system of nonlinear equations
Next: How to use NNARX model in simulink