Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2010

[Date Index] [Thread Index] [Author Index]

Search the Archive

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
>
>
>  



  • Prev by Date: how to scale text to a bounding rectangle?
  • Next by Date: Re: WORKBENCH VS MATHEMATICA
  • Previous by thread: Re: Excel Data Managing
  • Next by thread: Re: Excel Data Managing