Re: [R] Sorting alphanumerically

From: Mark <mtb954_at_gmail.com>
Date: Sat 25 Feb 2006 - 15:21:58 EST

Thank you all, for your help.
Mark

On 2/24/06, Chuck Cleland <ccleland@optonline.net> wrote:
> Does this help?
>
> ID <- paste("g", sample(1:100, 100, replace=FALSE), sep="")
>
> ID
> [1] "g88" "g5" "g79" "g67" "g43" "g21" "g66"
> [8] "g9" "g38" "g86" "g12" "g85" "g74" "g34"
> [15] "g52" "g95" "g6" "g22" "g70" "g87" "g7"
> [22] "g83" "g63" "g42" "g26" "g65" "g16" "g97"
> [29] "g76" "g2" "g90" "g23" "g15" "g82" "g75"
> [36] "g58" "g17" "g20" "g96" "g91" "g31" "g33"
> [43] "g48" "g32" "g93" "g54" "g49" "g36" "g81"
> [50] "g57" "g27" "g14" "g62" "g10" "g80" "g71"
> [57] "g28" "g37" "g89" "g8" "g94" "g68" "g56"
> [64] "g92" "g41" "g11" "g4" "g99" "g55" "g60"
> [71] "g18" "g69" "g19" "g64" "g39" "g1" "g53"
> [78] "g44" "g24" "g100" "g35" "g3" "g40" "g47"
> [85] "g51" "g46" "g61" "g45" "g50" "g25" "g13"
> [92] "g73" "g77" "g30" "g84" "g78" "g29" "g59"
> [99] "g72" "g98"
>
> ID[order(as.numeric(substr(ID, start=2, stop=nchar(ID))))]
> [1] "g1" "g2" "g3" "g4" "g5" "g6" "g7"
> [8] "g8" "g9" "g10" "g11" "g12" "g13" "g14"
> [15] "g15" "g16" "g17" "g18" "g19" "g20" "g21"
> [22] "g22" "g23" "g24" "g25" "g26" "g27" "g28"
> [29] "g29" "g30" "g31" "g32" "g33" "g34" "g35"
> [36] "g36" "g37" "g38" "g39" "g40" "g41" "g42"
> [43] "g43" "g44" "g45" "g46" "g47" "g48" "g49"
> [50] "g50" "g51" "g52" "g53" "g54" "g55" "g56"
> [57] "g57" "g58" "g59" "g60" "g61" "g62" "g63"
> [64] "g64" "g65" "g66" "g67" "g68" "g69" "g70"
> [71] "g71" "g72" "g73" "g74" "g75" "g76" "g77"
> [78] "g78" "g79" "g80" "g81" "g82" "g83" "g84"
> [85] "g85" "g86" "g87" "g88" "g89" "g90" "g91"
> [92] "g92" "g93" "g94" "g95" "g96" "g97" "g98"
> [99] "g99" "g100"
>
> The idea is to drop the leading "g", convert to numeric, and then order.
>
> mtb954 mtb954 wrote:
> > I'm trying to sort a DATAFRAME by a column "ID" that contains
> > alphanumeric data. Specifically,"ID" contains integers all preceeded
> > by the character "g" as in:
> >
> > g1, g6, g3, g19, g100, g2, g39
> >
> > I am using the following code:
> >
> > DATAFRAME=DATAFRAME[order(DATAFRAME1$ID),]
> >
> > and was hoping it would sort the dataframe by ID in the following manner
> >
> > g1, g2, g3, g6, g19, g39, g100
> >
> > but it doesn't sort at all. Could anyone point out my mistake?
> >
> > Thank you.
> >
> > Mark
> >
> > ______________________________________________
> > R-help@stat.math.ethz.ch mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
> >
>
> --
> Chuck Cleland, Ph.D.
> NDRI, Inc.
> 71 West 23rd Street, 8th floor
> New York, NY 10010
> tel: (212) 845-4495 (Tu, Th)
> tel: (732) 452-1424 (M, W, F)
> fax: (917) 438-0894
>



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Sat Feb 25 15:34:39 2006

This archive was generated by hypermail 2.1.8 : Sun 26 Feb 2006 - 00:08:44 EST