Re: [R] sorting the data~

From: Philipp Pagel <p.pagel_at_wzw.tum.de>
Date: Thu, 05 Jun 2008 09:05:25 +0200

On Wed, Jun 04, 2008 at 07:36:04PM -0600, Manli Yan wrote:
> no,the id is variable of a table,such as:
> treatment id age response
> low 1 50 20
> low 1 60 30
> high 5 50 30
> high 5 60 40
>
> .......
>
> I want to rearranage the table according the id (increasing)

Ah - that's a different story. To sort your data frame by id:

foo <- foo[order(foo$id), ]

> ,since id is not strictly from 1~n,it is in increasing order but
> sometime jump through many number like 1 1 5 5,I like them to be 1 1 2
> 2~

foo$id <- as.integer(factor(foo$id))

seems to do what wou want, except I am not sure if factor is guaranteed to encode the values in ascending order. If it isn't this is a bad idea. Alternatively, this should work:

foo$id <- cumsum(as.logical(diff(foo$id))) + 1

I'm sure there is a more elegant way but can't think of one right now.

cu

        Philipp

-- 
Dr. Philipp Pagel
Lehrstuhl für Genomorientierte Bioinformatik
Technische Universität München
Wissenschaftszentrum Weihenstephan
85350 Freising, Germany
http://mips.gsf.de/staff/pagel

______________________________________________
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.
Received on Thu 05 Jun 2008 - 07:33:59 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 05 Jun 2008 - 09:30:38 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive