Re: Excel Data Managing
- To: mathgroup at smc.vnet.net
- Subject: [mg110355] Re: Excel Data Managing
- From: "Sjoerd C. de Vries" <sjoerd.c.devries at gmail.com>
- Date: Tue, 15 Jun 2010 02:28:34 -0400 (EDT)
- References: <hv3nh8$qq$1@smc.vnet.net>
Hi Matteo,
First you have to throw away the text headers using Drop or Take.
Are you sure that each data triplet has two sets of curly brackets
around it? It looks unusual, not what I normally get when I import
from Excel. Assuming you put the rest of the dataset in the variable
data I'd suggest getting rid of the extra layer of brackets using
Flatten:
data = Flatten[data, 1]
If you want to plot Price against Year you could use ListPlot or
DateListPlot as follows:
ListPlot[Transpose[{ data[[All,1]], data[[All,2]] } ] .
data[[All,1]] takes the first column of the dataset and data[[All,2]]
takes the second. Putting them in a new list with { } and using
Transpose makes it a list with data pairs.
An alternative approach would be:
ListPlot[Transpose[{ Transpose[data][[1]], Transpose[data][[1]] } ]
Cheers -- Sjoerd
On Jun 14, 12:53 am, Sharing the Jazz <formenti.mat... at gmail.com>
wrote:
> 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