Re: [R] sorting the data~
On Thu, Jun 05, 2008 at 09:05:25AM +0200, Philipp Pagel wrote: > a bad idea. Alternatively, this should work: > > foo$id <- cumsum(as.logical(diff(foo$id))) + 1 I should have explicitly said that this only works after sorting, of course. 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@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.
Re: [R] sorting the data~
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 > high5 50 30 > high5 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@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.
Re: [R] sorting the data~
id<-c(1,1,1,1,3,3,3,7,7,7,7,11,11,11,2,2,2,4,4,4,4,8,8,8)
sort(id)
[1] 1 1 1 1 2 2 2 3 3 3 4 4 4 4 7 7 7 7 8 8 8 11 11 11
Quoting Manli Yan <[EMAIL PROTECTED]>:
no,the id is variable of a table,such as:
treatment id age response
low 1 50 20
low 1 60 30
high5 50 30
high5 60 40
...
I want to rearranage the table according the id (increasing),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~
2008/6/4 Erik Iverson <[EMAIL PROTECTED]>:
Are these the ranks of the data?
help.search("rank")
Manli Yan wrote:
id<-c(1,1,1,1,3,3,3,7,7,7,7,11,11,11)
how to sort this kind of data to
id:(1,1,1,1,2,2,2,3,3,3,3,4,4,4.)
thanks~
[[alternative HTML version deleted]]
__
R-help@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.
[[alternative HTML version deleted]]
__
R-help@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.
__
R-help@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.
Re: [R] sorting the data~
no,the id is variable of a table,such as:
treatment id age response
low 1 50 20
low 1 60 30
high5 50 30
high5 60 40
...
I want to rearranage the table according the id (increasing),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~
2008/6/4 Erik Iverson <[EMAIL PROTECTED]>:
> Are these the ranks of the data?
>
> help.search("rank")
>
>
>
> Manli Yan wrote:
>
>>id<-c(1,1,1,1,3,3,3,7,7,7,7,11,11,11)
>>
>> how to sort this kind of data to
>> id:(1,1,1,1,2,2,2,3,3,3,3,4,4,4.)
>>
>> thanks~
>>
>>[[alternative HTML version deleted]]
>>
>> __
>> R-help@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.
>>
>
[[alternative HTML version deleted]]
__
R-help@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.
Re: [R] sorting the data~
Are these the ranks of the data?
help.search("rank")
Manli Yan wrote:
id<-c(1,1,1,1,3,3,3,7,7,7,7,11,11,11)
how to sort this kind of data to
id:(1,1,1,1,2,2,2,3,3,3,3,4,4,4.)
thanks~
[[alternative HTML version deleted]]
__
R-help@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.
__
R-help@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.
[R] sorting the data~
id<-c(1,1,1,1,3,3,3,7,7,7,7,11,11,11) how to sort this kind of data to id:(1,1,1,1,2,2,2,3,3,3,3,4,4,4.) thanks~ [[alternative HTML version deleted]] __ R-help@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.
