Thank you very much DJ MuseR!


Curtis K

~ Sent from a PDA. I apologize in advance for any typing errors. 



On Nov 8, 2011, at 4:36 PM, "djmuseR [via R]" <ml-node+s789695n4018171h84@n4.nabble.com> wrote:

> Here's another approach using the plyr and data.table packages, where 
> df is the name I gave to your example data: 
> 
> # plyr 
> library('plyr') 
> ddply(df, .(TIME), mutate, L1 = sort(S1)) 
> 
> # Another way with the data.table package: 
> library('data.table') 
> dt <- data.table(df, key = 'TIME') 
> dt[, list(X1, S1, L1 = sort(S1)), by = 'TIME'] 
> 
> HTH, 
> Dennis 
> 
> On Tue, Nov 8, 2011 at 11:58 AM, economicurtis <[hidden email]> wrote: 
> 
> > I have panel data in the following form: 
> > 
> > TIME   X1     S1 
> >  1       1      0.99 
> >  1       2      0.50 
> >  1       3      0.01 
> >  2       3      0.99 
> >  2       1      0.99 
> >  2       2      0.25 
> >  3       3      0.75 
> >  3       2      0.50 
> >  3       1      0.25 
> > ...      ...     ...... 
> > 
> > And desire a new vector of observations in which one column (S1 above) is 
> > sorted for each second from least to largest. 
> > 
> > That is, a new vector (L1 below) of the form: 
> > 
> > TIME   X1     S1       L1 
> >  1       1      0.99    0.01 
> >  1       2      0.50    0.50 
> >  1       3      0.01    0.99 
> >  2       3      0.99    0.25 
> >  2       1      0.99    0.99 
> >  2       2      0.25    0.99 
> >  3       3      0.75    0.25 
> >  3       2      0.50    0.50 
> >  3       1      0.25    0.75 
> > ...      ...     ......    ..... 
> > 
> > Sorry for the NOOB question, but any help would be great. 
> > 
> > Curtis Kephart 
> > 
> > -- 
> > View this message in context: http://r.789695.n4.nabble.com/Sorting-Panel-Data-by-Time-tp4017271p4017271.html
> > Sent from the R help mailing list archive at Nabble.com. 
> > 
> > ______________________________________________ 
> > [hidden email] 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. 
> >
> 
> ______________________________________________ 
> [hidden email] 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. 
> 
> 
> If you reply to this email, your message will be added to the discussion below:
> http://r.789695.n4.nabble.com/Sorting-Panel-Data-by-Time-tp4017271p4018171.html
> To unsubscribe from Sorting Panel Data by Time, click here.
> See how NAML generates this email


--
View this message in context: http://r.789695.n4.nabble.com/Sorting-Panel-Data-by-Time-tp4017271p4018372.html
Sent from the R help mailing list archive at Nabble.com.
	[[alternative HTML version deleted]]

