Hello All,
I am in need of your help. It is probably something small I am missing, but I am trying to take percentages in a column and mutate those into a new column and then use ifelse to put the percentages into categories such as good or bad.
The column is titled PovertyLev and uses percentages to gauge a persons poverty level
example = 76%
I want to create a new column and categorize poverty rates.
Do I need to convert and do something before I can categorize everything correctly?
Here is the coding structure I am using:
DF <- MASTER.SERVICE.REPORT.(3)%>%
mutate(Eligability2 = if_else(PovertyLev >200%, "Good", "Bad"))
However, when I use the coding structure shown above, I get this error in R
Error: unexpected input in:
"DF <- MASTER.SERVICE.REPORT.(3)%>%
mutate(Eligability2 = if_else(PovertyLev > 200%, "Good", "Bad"))"
All the help is greatly appreciated.
Thank you,