[R] data format setting

[Jeff Newmiller]

As always, you are requested to post in plain text and to provide a reproducible example. "Messed things up" is quite vague.
FWIW: In general, processing in sequence is best done BEFORE you cast your data to wide format.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

On June 13, 2014 12:46:01 PM MDT, eliza botto <eliza_botto at hotmail.com> wrote:
>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 at gmail.com
>> To: eliza_botto at 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 at 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 at 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]]
>
>______________________________________________
>R-help at 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.