Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Replacing numbers within a range with a factor [duplicate]

Given a dataframe column which is a series of integers (age), I want to convert ranges of integers into ordinal variables.

My current code doesn't work, how do I do this?

df <- read.table("http://dl.dropbox.com/u/822467/df.csv", header = TRUE, sep = ",")

df[(df >= 0)  & (df <= 14)] <- "Age1"
df[(df >= 15) & (df <= 44)] <- "Age2"
df[(df >= 45) & (df <= 64)] <- "Age3"
df[(df > 64)] <- "Age4"

table(df)
like image 851
R J Avatar asked Apr 19 '12 06:04

R J


1 Answers

Use cut to do this in one step:

dfc <- cut(df$x, breaks=c(0, 15, 45, 56, Inf))
str(dfc)
 Factor w/ 4 levels "(0,15]","(15,45]",..: 3 4 3 2 2 4 2 2 4 4 ...

Once you are satisfied that the breaks are correctly specified, you can then also use the labels argument to relabel the levels:

dfc <- cut(df$x, breaks=c(0, 15, 45, 56, Inf), labels=paste("Age", 1:4, sep=""))
str(dfc)
 Factor w/ 4 levels "Age1","Age2",..: 3 4 3 2 2 4 2 2 4 4 ...
like image 81
Andrie Avatar answered Nov 04 '22 02:11

Andrie