CODEWITHSUNDEEP
rdataframeif-statement
learner
learner

Reputation: 194

Changing specific column values based on conditions in R

I have following dataframe named 'Saty' in R

One_Day Arrived_Date Departure_Date
Yes 2022-01-10 NA
No 2021-05-12 2021-06-01
Yes 2021-12-01 2021-12-01
Yes 2022-03-01 NA

I want to modify the dataframe, if the One_Day column value is 'Yes', my 'Arrived_Date' and 'Departure_Date' should be same, like below dataframe.

One_Day Arrived_Date Departure_Date
Yes 2022-01-10 2022-01-10
No 2021-05-12 2021-06-01
Yes 2021-12-01 2021-12-01
Yes 2022-03-01 2022-03-01

How to achieve this by coding in R ?

Upvotes: 0

Views: 38

Answers (2)

TarJae
TarJae

Reputation: 78917

With the shown data this also works: coalesce

Nevertheless, I am quite sure for your original data you will need an ifelse statement as @benson23+1 provided, but this is may be also interesting for you:

libray(dplyr)

df %>% 
  mutate(Departure_Date = coalesce(Departure_Date, Arrived_Date))

  One_Day Arrived_Date Departure_Date
1     Yes   2022-01-10     2022-01-10
2      No   2021-05-12     2021-06-01
3     Yes   2021-12-01     2021-12-01
4     Yes   2022-03-01     2022-03-01

Upvotes: 2

benson23
benson23

Reputation: 19097

What you need is an ifelse statement.

library(dplyr)

Saty %>% mutate(Departure_Date = ifelse(One_Day == "Yes", Arrived_Date, Departure_Date))

  One_Day Arrived_Date Departure_Date
1     Yes   2022-01-10     2022-01-10
2      No   2021-05-12     2021-06-01
3     Yes   2021-12-01     2021-12-01
4     Yes   2022-03-01     2022-03-01

Upvotes: 3

Related Questions