Dear ALL, I fear my question has already been answered many times before, but I haven't fund that in archives... I am working on spatial datasets and, in most arrays I'm handling, there are two columns dedicated to (x,y)-coords. For different reasons - notably to draw image() plots, I need to have these two columns sorted in increasing order. But sort() and order() seem to apply to vectors - or one single column - only. Could somedy please let me know how to sort two columns of a dataframe, with priority to one of them, just like in access ? Thanks, Jacques VESLOT CIRAD Another related question : How to put legend on image() plots - or image-based plots like image.kriging() in geoR ? Despite help pages, I haven't succeeded. ----------------------------------------------------- CIRAD 3P Reunion - MailScanner ----------------------------------------------------- Ce message a ??t?? v??rifi?? par MailScanner et analyse par 4 antivirus : ClamAv - BitDefender - F-Prot - Panda. Aucun virus,ni rien de suspect n'a ??t?? trouv??. This message has been scanned for viruses and dangerous content, and is believed to be clean.
Jacques VESLOT wrote:> Dear ALL, > > I fear my question has already been answered many times before, but I > haven't fund that in archives... > > I am working on spatial datasets and, in most arrays I'm handling, there are > two columns dedicated to (x,y)-coords. > For different reasons - notably to draw image() plots, I need to have these > two columns sorted in increasing order. > But sort() and order() seem to apply to vectors - or one single column - > only. > > Could somedy please let me know how to sort two columns of a dataframe, with > priority to one of them, just like in access ?See ?order Uwe Ligges> Thanks, > > Jacques VESLOT > CIRAD > > Another related question : > How to put legend on image() plots - or image-based plots like > image.kriging() in geoR ? > Despite help pages, I haven't succeeded. > > > > ----------------------------------------------------- > CIRAD 3P Reunion - MailScanner > ----------------------------------------------------- > Ce message a ??t?? v??rifi?? par MailScanner > et analyse par 4 antivirus : > ClamAv - BitDefender - F-Prot - Panda. > > Aucun virus,ni rien de suspect n'a ??t?? trouv??. > > This message has been scanned for viruses and > dangerous content, and is believed to be clean. > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Hoi Jacques, --On woensdag 21 juli 2004 10:35 +0400 Jacques VESLOT <jacques.veslot at cirad.fr> wrote:> Could somedy please let me know how to sort two columns of a dataframe, > with priority to one of them, just like in access ? >Would this <http://www.ku.edu/~pauljohn/R/Rtips.html#2.12> help? kind regards, Paul -- Paul Lemmens NICI, University of Nijmegen ASCII Ribbon Campaign /"\ Montessorilaan 3 (B.01.05) Against HTML Mail \ / NL-6525 HR Nijmegen X The Netherlands / \ Phonenumber +31-24-3612648 Fax +31-24-3616066
Hi,
It would be discussed yesterday.
See e.g. in Google for ("sorting a data frame" R)
http://www.r-project.org/nocvs/mail/r-help/2002/0088.html
Or one entry yesterday:
Best,
Matthias
>Hi
>Lets assign your data frame to the variable yourdf
>then:
>yourdf[ , order( yourdf$year ) ]
>should sort it.
>For decreasing increasing sorting
>see
>?order
>Sincerely Eryk.
>*********** REPLY SEPARATOR ***********
>On 20.07.2004 at 09:51 Luis Rideau Cruz wrote:
>Hi all
>
>I have the next data frame
>
> year STOD SLAGNR TAL TALT TALVEKT
>1 2002 2120006 57 1 NA 1
>2 1997 97030032 57 NA NA NA
>3 1997 97030071 27 1 NA NA
>4 1997 97030005 57 1 NA NA
>5 1997 97020127 60 NA 1 NA
>6 2001 1160025 27 1 NA 1
>7 1998 98020069 60 1 NA NA
>8 1996 96030009 57 NA 1 NA
>
>How to sort it according to "year" column
>Sort does seem to work only on vectors
>
>Thank you
>
>Luis Ridao Cruz
>Fiskiranns??knarstovan
>N??at??n 1
>P.O. Box 3051
>FR-110 T??rshavn
>Faroe Islands
>Phone: +298 353900
>Phone(direct): +298 353912
>Mobile: +298 580800
>Fax: +298 353901
>E-mail: luisr at frs.fo
>Web: www.frs.fo
>
>
> Dear ALL,
>
> I fear my question has already been answered many times
> before, but I haven't fund that in archives...
>
> I am working on spatial datasets and, in most arrays I'm
> handling, there are two columns dedicated to (x,y)-coords.
> For different reasons - notably to draw image() plots, I need
> to have these two columns sorted in increasing order. But
> sort() and order() seem to apply to vectors - or one single
> column - only.
>
> Could somedy please let me know how to sort two columns of a
> dataframe, with priority to one of them, just like in access ?
>
> Thanks,
>
> Jacques VESLOT
> CIRAD
>
> Another related question :
> How to put legend on image() plots - or image-based plots like
> image.kriging() in geoR ?
> Despite help pages, I haven't succeeded.
>
>
>
> -----------------------------------------------------
> CIRAD 3P Reunion - MailScanner
> -----------------------------------------------------
> Ce message a ??t?? v??rifi?? par MailScanner
> et analyse par 4 antivirus :
> ClamAv - BitDefender - F-Prot - Panda.
>
> Aucun virus,ni rien de suspect n'a ??t?? trouv??.
>
> This message has been scanned for viruses and
> dangerous content, and is believed to be clean.
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo> /r-help
> PLEASE
> do read the posting guide!
> http://www.R-project.org/posting-guide.html
>