Creating a new variable from a lookup table

by

Here is how to use a named vector for the lookup:

Define test data:

dat <- data.frame(
    presult = c(rep("I", 4), "SS", "ZZ"),
    aresult = c("single", "double", "triple", "home run", "strikeout", "home run"),
    stringsAsFactors=FALSE
)

Define a named numeric vector with the scores:

score <- c(single=1, double=2, triple=3, `home run`=4,  strikeout=0)

Use vector indexing to match the scores against results:

dat$base <- score[dat$aresult]
dat
  presult   aresult base
1       I    single    1
2       I    double    2
3       I    triple    3
4       I  home run    4
5      SS strikeout    0
6      ZZ  home run    4

Additional information:

If you don’t wish to construct the named vector by hand, say in the case where you have large amounts of data, then do it as follows:

scores <- c(1:4, 5)
names(scores) <- c("single", "double", "triple", "home run", "strikeout")

(Or read the values and names from existing data. The point is to construct a numeric vector and then assign names.)

More Related Contents:

  1. Repeat each row of data.frame the number of times specified in a column
  2. Filter data.frame rows by a logical condition
  3. Split column at delimiter in data frame [duplicate]
  4. Pass a data.frame column name to a function
  5. How to convert a list consisting of vector of different lengths to a usable data frame in R?
  6. Select groups based on number of unique / distinct values
  7. Assign multiple columns using := in data.table, by group
  8. Filtering a data frame on a vector [duplicate]
  9. How to replace NA values in a table for selected columns
  10. Remove an entire column from a data.frame in R
  11. Selecting multiple odd or even columns/rows for dataframe
  12. Sample n random rows per group in a dataframe
  13. Deleting reversed duplicates with R
  14. Select every nth row from dataframe
  15. Remove Rows From Data Frame where a Row matches a String
  16. duplicates in multiple columns
  17. R – add column that counts sequentially within groups but repeats for duplicates
  18. Extend contigency table with proportions (percentages)
  19. Splitting a data.frame by a variable [duplicate]
  20. Check whether values in one data frame column exist in a second data frame
  21. How do you remove columns from a data.frame?
  22. Unlist a data frame by rows, not columns
  23. Deleting columns from a data.frame where NA is more than 15% of the column length [duplicate]
  24. Using lapply to apply a function over list of data frames and saving output to files with different names
  25. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  26. Return df with a columns values that occur more than once [duplicate]
  27. Row-wise sum of values grouped by columns with same name
  28. Replicate each row of data.frame and specify the number of replications for each row?
  29. R how can I calculate difference between rows in a data frame
  30. Color one point and add an annotation in ggplot2?

Leave a Comment