Sorting a data frame by specifying a vector
On Thu, Oct 11, 2012 at 10:43 AM, ROLL Josh F <JRoll at lcog.org> wrote:
Sorry if I wasn't clear.
Actually, my bad -- I didn't read carefully enough.
But the answer is still essentially correct -- just change the
ordering of the levels of Season, which, by default, is alphabetic.
df$Season <- factor(df$Season, lev = c("Summer","Fall","Winter","Spring"))
df <- df[order(df$Season),]
Learn about factors (Read the Intro to R tutorial if you haven't
already). They are very handy (and much despised by some).
-- Bert
The result I am looking for would be something like:
# Season Obs #1 Summer 0.2141001 #5 Summer 0.2141001 #9 Summer 0.2141001 #13 Summer 0.2141001 #3 Fall 0.6722337 #7 Fall 0.6722337 #11 Fall 0.6722337 #15 Fall 0.6722337 #2 Winter 0.9318599 #6 Winter 0.9318599 #10 Winter 0.9318599 #14 Winter 0.9318599 #4 Spring 0.1927715 #8 Spring 0.1927715 #12 Spring 0.1927715 #16 Spring 0.1927715 Any other thoughts? JR -----Original Message----- From: Bert Gunter [mailto:gunter.berton at gene.com] Sent: Thursday, October 11, 2012 10:19 AM To: ROLL Josh F Cc: r-help at r-project.org Subject: Re: [R] Sorting a data frame by specifying a vector ?order df[order(yourcolumn, ] -- Bert On Thu, Oct 11, 2012 at 10:08 AM, LCOG1 <jroll at lcog.org> wrote:
Hello all,
I cannot seem to figure out this seemingly simple procedure.
I want to sort a data frame by a specified character vector.
So for :
df.. <-
data.frame(Season=rep(c("Summer","Fall","Winter","Spring"),4),Obs=
runif(length(rep(c("Summer","Fall","Winter","Spring"),4))))
I want to sort the data frame by the seasons but in the order I
specify since alphapetically would not put the season in sequential
order
I tried the following and a few other things but no dice. It looks
like I will have to convert to factors. Any thoughts? Thanks
df.. <-
df..[sort(as.factor(Df..$Season,levels=c("Summer","Fall","Winter","Spr
ing"))),]
Josh
--
View this message in context:
http://r.789695.n4.nabble.com/Sorting-a-data-frame-by-specifying-a-vec
tor-tp4645867.html Sent from the R help mailing list archive at
Nabble.com.
______________________________________________ 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.
-- Bert Gunter Genentech Nonclinical Biostatistics Internal Contact Info: Phone: 467-7374 Website: http://pharmadevelopment.roche.com/index/pdb/pdb-functional-groups/pdb-biostatistics/pdb-ncb-home.htm
Bert Gunter Genentech Nonclinical Biostatistics Internal Contact Info: Phone: 467-7374 Website: http://pharmadevelopment.roche.com/index/pdb/pdb-functional-groups/pdb-biostatistics/pdb-ncb-home.htm