Re: Excel Data Managing
- To: mathgroup at smc.vnet.net
- Subject: [mg110349] Re: Excel Data Managing
- From: Christopher Arthur <aarthur at tx.rr.com>
- Date: Tue, 15 Jun 2010 02:27:27 -0400 (EDT)
Probably the double braces are confusing the program.
try this:
Flatten/@data
and use the result (such that 'data' is the entire spreadsheet).
Chris
Sharing the Jazz a =E9crit :
> Hi,
> I import a dataset of three variable from excel to mathematica. The
> input works but i don't know how to work on it, for example plot it,
> analyze stationarity. The problem is that they are on this form and
> Mathematica (with Time Series application) doesn't work.
>
> {{{"Year", "Price", "Dividend"}}, {{1871., 77.2276,
> 4.52234}}, {{1872., 83.2615, 4.51085}}, ..... {{2009., 888.75,
> 28.7598}}}
>
> Can someone help me in start using this data?
>
> Thank you very much,
>
> Matteo
> HEC-Paris
>
>
>