Defining categories
Hi,
?(Jorge: Thanks for the suggestion.)
cut? will be much easier.
dat1<-read.table(text="
2.880556
0.616667
5.083333
0.858333
0.466667
2.936111
4.258333
0.258333
2.033333
2.583333
1.088889
0.447222
1.872222
0.080556
4.033333
4.116667
1.633333
2.147222
",sep="",header=FALSE)
?dat1$Categ<-cut(dat1$V1,breaks=c(0,1,2,3,4,5,6))
#Either
library(car)
dat1$Categ<-recode(dat1$Categ,"'(0,1]'=1;'(1,2]'=2;'(2,3]'=3;'(3,4]'=4;'(4,5]'=5;'(5,6]'=6")
#or
dat1$Categ<-as.numeric(gsub(".*\\,(\\d+).*","\\1",dat1$Categ))
#formats the Categ column.
head(dat1)
#??????? V1 Categ
#1 2.880556???? 3
#2 0.616667???? 1
#3 5.083333???? 6
#4 0.858333???? 1
#5 0.466667???? 1
#6 2.936111???? 3
A.K.
From: Jorge I Velez <jorgeivanvelez at gmail.com>
To: arun <smartpink111 at yahoo.com>
Cc: bibek sharma <mbhpathak at gmail.com>; R help <r-help at r-project.org>
Sent: Wednesday, October 24, 2012 7:27 PM
Subject: Re: [R] Defining categories
To: arun <smartpink111 at yahoo.com>
Cc: bibek sharma <mbhpathak at gmail.com>; R help <r-help at r-project.org>
Sent: Wednesday, October 24, 2012 7:27 PM
Subject: Re: [R] Defining categories
See ?cut for a simpler way of doing this. HTH, Jorge.- On Thu, Oct 25, 2012 at 10:02 AM, arun <> wrote: Hi, >May be this: >dat1<-read.table(text=" > >2.880556 >0.616667 >5.083333 >0.858333 >0.466667 >2.936111 >4.258333 >0.258333 >2.033333 >2.583333 >1.088889 >0.447222 >1.872222 >0.080556 >4.033333 >4.116667 >1.633333 >2.147222 >",sep="",header=FALSE) >dat1$category<-ifelse(dat1$V1<=1 &dat1$V1>0,1,ifelse(dat1$V1>1 & dat1$V1<=2,2,ifelse(dat1$V1>2&dat1$V1<=3,3,ifelse(dat1$V1>3&dat1$V1<=4,4,ifelse(dat1$V1>4&dat1$V1<=5,5,6))))) > > >?head(dat1) >#??????? V1 category >#1 2.880556??????? 3 >#2 0.616667??????? 1 >#3 5.083333??????? 6 >#4 0.858333??????? 1 >#5 0.466667??????? 1 >#6 2.936111??????? 3 >A.K. > > > > >----- Original Message ----- >From: bibek sharma <> >To: r-help at r-project.org >Cc: >Sent: Wednesday, October 24, 2012 6:52 PM >Subject: [R] Defining categories > >Hello R user, > >Data below represent year in decimal. I would like to catagorize it >in such a way that any valye [0,1] goes to catagory 1 , (1,2] goes to >catagory 2 and so on.. >Any suggestion how it can be done with if else statement or any other way? > >2.880556 >0.616667 >5.083333 >0.858333 >0.466667 >2.936111 >4.258333 >0.258333 >2.033333 >2.583333 >1.088889 >0.447222 >1.872222 >0.080556 >4.033333 >4.116667 >1.633333 >2.147222 > >Thank you for? your help. >Bibek > >______________________________________________ >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. > > >______________________________________________ >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. >