Replace values in a dataframe based on lookup table

by

You posted an approach in your question which was not bad. Here’s a smiliar approach:

new <- df  # create a copy of df
# using lapply, loop over columns and match values to the look up table. store in "new".
new[] <- lapply(df, function(x) look$class[match(x, look$pet)])

An alternative approach which will be faster is:

new <- df
new[] <- look$class[match(unlist(df), look$pet)]

Note that I use empty brackets ([]) in both cases to keep the structure of new as it was (a data.frame).

(I’m using df instead of table and look instead of lookup in my answer)

More Related Contents:

  1. Replace specific values based on another dataframe
  2. Dynamically select data frame columns using $ and a character value
  3. Simultaneously merge multiple data.frames in a list
  4. Drop unused factor levels in a subsetted data frame
  5. Why is it not advisable to use attach() in R, and what should I use instead?
  6. Opposite of %in%: exclude rows with values specified in a vector
  7. Select rows with min value by group
  8. Repeat rows of a data.frame N times
  9. Replace all occurrences of a string in a data frame
  10. Convert Named Character Vector to data.frame
  11. How to add a cumulative column to an R dataframe using dplyr?
  12. Get last row of each group in R [duplicate]
  13. Create empty data frame with column names by assigning a string vector? [duplicate]
  14. Add extra level to factors in dataframe
  15. Dataframe create new column based on other columns
  16. What is about the first column in R’s dataset mtcars?
  17. Determine the data types of a data frame’s columns
  18. finding close match from data frame 1 in data fame 2
  19. Combine several data frames in the global environment by row (rbind)
  20. Changing Million/Billion abbreviations into actual numbers? ie. 5.12M -> 5,120,000 [duplicate]
  21. Extract text after “/” in a data frame column
  22. What is difference between dataframe and list in R?
  23. use multiple columns as variables with sapply
  24. Merge overlapping ranges into unique groups, in dataframe
  25. Deleting specific rows from a data frame
  26. Reshape a dataframe to long format with multiple sets of measure columns [duplicate]
  27. Count number of non-NA values for every column in a dataframe [duplicate]
  28. Convert a data frame to a data.table without copy
  29. How can I merge more than 2 dataframes in R by rownames?
  30. What is the first column in R’s mtcars dataset?

Leave a Comment