R help - May 2013 - group data based on row value

hey, I want to divide my data into three groups based on the value in one
column with group name.

dat:

Var
0
0.2
0.5
1
4
6

I tried:

dat <- cbind(dat, group=cut(dat$Var, breaks=c(0.1,0.6)))

But it doesnt work, I want to group those <0.1 as group A, 0.1-0.6 as group
B, >0.6 as group C

Thanks for your help!

	[[alternative HTML version deleted]]

Hi,
Try:
dat<- read.table(text="
Var
0
0.2
0.5
1
4
6
",sep="",header=TRUE) 

res1<-within(dat,group<-factor(findInterval(Var,c(-Inf,0.1,0.6),rightmost.closed=TRUE),labels=LETTERS[1:3]))
?res1
?# Var group
#1 0.0???? A
#2 0.2???? B
#3 0.5???? B
#4 1.0???? C
#5 4.0???? C
#6 6.0???? C

#or

res2<-within(dat,group<-factor(cut(Var,breaks=c(-Inf,0.1,0.6,Inf)),labels=LETTERS[1:3]))
?identical(res1,res2)
#[1] TRUE
A.K.

>hey, I want to divide my data into three groups based on the value in one 
>column with group name. 
>
>dat: 
>
>Var 
>0 
>0.2 
>0.5 
>1 
>4 
>6 
>
>I tried: 
>
>dat <- cbind(dat, group=cut(dat$Var, breaks=c(0.1,0.6))) 
>
>But it doesnt work, I want to group those <0.1 as group A, 0.1-0.6 as
group
>B, >0.6 as group C 
>
>Thanks for your help!

dat$group <- cut( dat$Var, breaks=c(-Inf,0.1, 0.6,Inf))
levels(dat$group) <- LETTERS[1:3]

---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live
Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

Ye Lin <yelin at lbl.gov> wrote:
>hey, I want to divide my data into three groups based on the value in
>one
>column with group name.
>
>dat:
>
>Var
>0
>0.2
>0.5
>1
>4
>6
>
>I tried:
>
>dat <- cbind(dat, group=cut(dat$Var, breaks=c(0.1,0.6)))
>
>But it doesnt work, I want to group those <0.1 as group A, 0.1-0.6 as
>group
>B, >0.6 as group C
>
>Thanks for your help!
>
>	[[alternative HTML version deleted]]
>
>______________________________________________
>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.