Hi, why does my final ifelse fail with both Ed and Fred?
People <- c("Ann","Bill","Cathy","Dick","Ed","Fred")
Age <- c(20,30,40,50,80,NA)
df <- data.frame(cbind(People,Age))
df
df$Age <- ifelse(df$Age <= 29, "18-29",
ifelse(df$Age >= 30 & df$Age <= 44, "30-44",
ifelse(df$Age >= 45 & df$Age <= 59, "45-59",
ifelse(df$Age >= 60 & df$Age <= 74, "60-74",
ifelse(df$Age >= 75 & df$Age <= 120, "75+ ", "Unknown")))))
df
People Age
1 Ann 20
2 Bill 30
3 Cathy 40
4 Dick 50
5 Ed 80
6 Fred
People Age
1 Ann 18-29
2 Bill 30-44
3 Cathy 30-44
4 Dick 45-59
5 Ed Unknown
6 Fred