Match values in data frame with values in another data frame and replace former with a corresponding pattern from the other data frame

by

You could try: 

merge(d,m, by.x="v2", by.y="v3")
  v2 v1 v4
1  A  1  a
2  A  7  a
3  B  4  b
4  B  5  b
5  C  3  c
6  C  6  c
7  E  2  e
8  E  8  e

Edit

Here is another approach, to preserve the order:

data.frame(v1=d$v1, v4=m[match(d$v2, m$v3), 2])
  v1 v4
1  1  a
2  2  e
3  3  c
4  4  b
5  5  b
6  6  c
7  7  a
8  8  e

More Related Contents:

  1. How to replace NA values in a table for selected columns
  2. Replace all particular values in a data frame
  3. R: Replace multiple values in multiple columns of dataframes with NA
  4. finding close match from data frame 1 in data fame 2
  5. Replace in a factor column
  6. Replace empty values with value from other column in a dataframe
  7. Quickly reading very large tables as dataframes
  8. Counting unique / distinct values by group in a data frame
  9. cbind a dataframe with an empty dataframe – cbind.fill?
  10. Split a large dataframe into a list of data frames based on common value in column
  11. Splitting a dataframe string column into multiple different columns [duplicate]
  12. Convert data.frame column format from character to factor
  13. How to convert a table to a data frame
  14. How do I combine two data-frames based on two columns? [duplicate]
  15. R Apply() function on specific dataframe columns
  16. Count NAs per row in dataframe [duplicate]
  17. rbind dataframes with a different column name
  18. Converting two columns of a data frame to a named vector
  19. Collapsing data frame by selecting one row per group
  20. Creating a new variable from a lookup table
  21. Practical limits of R data frame
  22. rbind data frames based on a common pattern in data frame name
  23. Read and rbind multiple csv files
  24. How I can select rows from a dataframe that do not match?
  25. Join two data frames in R based on closest timestamp
  26. How to append a whole dataframe to a CSV in R
  27. Convert a data frame to a data.table without copy
  28. Shifting a column down by one
  29. Identifying where value changes in R data.frame column
  30. What is the first column in R’s mtcars dataset?

Leave a Comment