replacing multiple values with a specific date

Asked Jun 13 '19 at 08:25

Active Jun 13 '19 at 08:25

Viewed 98 times

I have a data frame in R with a column with values from 1 to 711. Each value is repeated multiple times. I want to replace each value with a specific DATE.

df <- data.frame(col1 = c(1,1,1,1,1,2,2,2,4,5,5,2,3) #711 values and total 
      entries = 300000
df1 <- data.frame(col2 = c("01-01-2014","02-01-2014","03-01-2014",04-01- 
       2014","05-01-2014") #711 unique dates

#Value 1 should be replaced by "01-01-2014"
#Value 2 should be replaced by "02-01-2014"
#......
#Value 711 should be replaced by "12-12-2015"

asked Jun 13 '19 at 08:25

Rohan Bali

Possible duplicate https://stackoverflow.com/questions/7547597/dictionary-style-replace-multiple-items – Ronak Shah Jun 13 '19 at 08:29
2

just using `df$col1 = df1$col2[df$col1]` ? – boski Jun 13 '19 at 08:30
df$col1 = df1$col2[df$col1] worked!. Thanks – Rohan Bali Jun 13 '19 at 08:43

replacing multiple values with a specific date

0 Answers0