new discrete variable with three levels (good, okay, bad)

Question

R has a built-in dataset called attitude. Create a new discrete variable complain.level with three levels, bad, okay and good.

ATTEMPT 1:

complain.level=revalue(attitude$complaints,c("bad"=(0:60),"okay"=(61:80), "good"=(81:100)))

boski · Accepted Answer · 2019-05-05T22:08:34.557

-1

You can use the following:

library(dplyr)
attitude%>%mutate(complaints.level = if_else(complaints<61,"bad",
                                             if_else(complaints>80,"good",
                                                     "okay")))

As suggested by Simon, we can also use case_when

attitude%>%mutate(complaints.level = case_when(complaints<61 ~ "bad",
                                               complaints>80 ~ "good",
                                               TRUE~"okay"))

edited May 05 '19 at 22:08

answered May 05 '19 at 21:02

boski

2,437
1
14
30

You should use `case_when` instead of nested `if_else`. – Simon Woodward May 05 '19 at 21:36
Is there a way without using the package "dplyr"? – Lexy Colberg May 05 '19 at 22:14
'data=data.frame(complain.level, attitude$complaints)' 'avg.cl<- tapply(data$attitude.complaints, data$complain.level, mean)' 'avg.cl' – Lexy Colberg May 06 '19 at 21:07

new discrete variable with three levels (good, okay, bad)

1 Answers1