Thanks dennis,
It worked but I had to do some simple modifications to get to the ultimate format.
Now I have a list in the following format
$A
2004	2005	2006	2007	2008	2009	2010
..
...
...
..
...

$AY

1967	1968	....	2000...........

some columns had 365 rows and some 366. those with 365 rows had their 366 row as NA. 
Now I want to apply approx. command to interpolate 366 values to 365, but when I apply approx command I gives out something 
which is with $x and $y, and frankly speaking it messed up everything.
Is their a way that i do it neatly without getting the format deteriorated?


In any way, thank-you very much indeed.

Eliza

> Date: Fri, 13 Jun 2014 11:11:37 -0700
> Subject: Re: [R] data format setting
> From: djmuser@gmail.com
> To: eliza_botto@hotmail.com
> 
> Hi:
> 
> Maybe something like this:
> 
> library(reshape2)
> L <- split(DF, DF$year)
> L2 <- llply(L, function(d) dcast(d, month + day ~ year, value.var =
> "discharge"))
> 
> Obviously untested, so caveat emptor. The idea is to use the dcast
> function to reshape the data from long to wide format within year.
> 
> Dennis
> 
> On Fri, Jun 13, 2014 at 8:55 AM, eliza botto <eliza_botto@hotmail.com> wrote:
> >
> > Dear R family,
> > I hope you all be doing great. I have a dataset of following format. The data file is of the following format.
> >
> >       st year month day discharge
> > 1  A     2004     1   1  6.752828
> > 2  A     2004     1   2  7.602053
> > 3  A     2004     1   3  5.583619
> > 4  A     2004     1   4  5.019562
> > 5  A     2004     1   5  4.804489
> > 6  A     2004     1   6  4.363541
> > 7  A     2004     1   7  3.801333
> > 8  A     2004     1   8  3.455991
> > 9  A     2004     1   9  3.402634
> > 10 A     2004     1  10  3.250693
> > ......
> > ......
> > continue
> > ......
> > ......
> >          st year month day discharge
> > 20000    AY 1967    10   3      0.56
> > 20001    AY 1967    10   4      0.56
> > 20002    AY 1967    10   5      0.48
> > 20003    AY 1967    10   6      0.56
> > 20004    AY 1967    10   7      0.48
> > 20005    AY 1967    10   8      0.40
> > 20006    AY 1967    10   9      0.40
> > 20007    AY 1967    10  10      0.56
> > 20008    AY 1967    10  11      0.56
> > 20009    AY 1967    10  12      0.65
> > 20010    AY 1967    10  13      0.85
> >
> > you can see that there are five columns.
> > The first column has the name of the station. I want to split the data w.r.t the names of the stations. Each station has data for certain years. for example "A" has data for years from 2004 to 2010 and for "AY" its from 1967 to 2000.similarly for other years there is data for different number of years.
> > I want to make a list of matrices each containing the data for that station in the following format
> > $A
> > 2004    2005    2006    2007    2008    2009    2010
> > ..
> > ...
> > ...
> > ..
> > ...
> >
> > $AY
> >
> > 1967    1968    ....    2000
> >
> > each column should have 365 to 366 values depending on whether there is a leap year or not. obviously for non-leap years 366th row should be an NA.
> > kindly help me on it.
> > Thankyou very much in advance.
> > Eliza
> >
> >
> >         [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help@r-project.org mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
 		 	   		  
	[[alternative HTML version deleted]]

