recode multiple variables with missing levels

Asked Dec 08 '15 at 18:28

Active Dec 08 '15 at 18:28

Viewed 100 times

I have a data frame with many columns of integer variables, each representing a particular question on a food frequency questionnaire. I want to recode these columns to numerical variables representing the number of servings of that food eaten per month. mapvalues() in plyr seems like the right function, but I keep getting warning messages because not all of the foods have the full range of responses recorded:

The following `from` values were not present in `x`: 4, 5, 6, 7, 8

Setting warn_missing = false does not return warning messages, but my data are still not being recoded.

Sample code (nails is my data frame, and foodnames is a list of variable names):

for (food in foodnames[c(7:81, 95:97)]){
  mapvalues(eval(parse(text=paste("nails$", food))), from = c(1:8),
            to = c(0, 1, 2.5, 4, 8, 14, 22, 28)), warn_missing = FALSE)
}

How can I get R to recode these variables even if they do not contain all the integers from 1 to 8? Thanks in advance.

asked Dec 08 '15 at 18:28

Alex P.

1

Please show a small reproducible example. We don't need `eval(parse` for this – akrun Dec 08 '15 at 18:30
1

[Info on how to give a reproducible example](http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example/5963610) – Jaap Dec 08 '15 at 18:34
Here's a reproducible example: `df – Alex P. Dec 10 '15 at 23:20
On the other hand, this code correctly recodes C: `df$C – Alex P. Dec 10 '15 at 23:23

recode multiple variables with missing levels

0 Answers0