How to replace multiple values in a dataframe column with another value?

Question

I have a dataframe with a structure like this.

head(df,n=5)
    Var1 Var2 Var3 value
1    1    1    1    NA
2    2    1    1    NA
3    3    1    1    NA
4    4    1    1    NA
5    5    1    1    NA

var3 as shown has value 1 for some rows(~500), 2 for some and so on till 366. I have a Date type stored with dates in the form

 head(date,n=5)
  "2020-01-01" "2020-01-02" "2020-01-03" "2020-01-04" "2020-01-05"

what I want to achieve is to replace var3 variable with dates as it represents the layer of the multidimensional array. i.e replace all 1 value with 2020-01-01, 2 with 2020-01-02 and so on. essentially making the df into the following

    Var1 Var2 Var3         value
1    1    1    2020-01-01    NA
2    2    1    2020-01-01    NA
3    3    1    2020-01-01    NA
4    4    1    2020-01-01    NA
5    5    1    2020-01-01    NA

how should I approach this issue?

transform(df, Var3 = date[Var3])

Onyambu
– Onyambu

2022-10-03 21:51:47 +00:00
Commented Oct 3, 2022 at 21:51 — Onyambu
– Onyambu, Commented Oct 3, 2022 at 21:51

Jc Bodoque · Accepted Answer · 2022-10-04 19:07:31Z

1

you can replace var3 by adding var3 and a fixed date point. Using tidyverse, it looks like:

df <- df %>% mutate(var3=as.Date(var3, origin = "2019-12-31"))

that means var3 (numbers) is considered as days after 2019/dec/31

answered Oct 4, 2022 at 19:07

Jc Bodoque

111 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to replace multiple values in a dataframe column with another value?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related