You want to use R to replace column values with NAs in other columns

Cleaning data using R.
Below are three columns (ID, s1, s2) with two missing s1.
If there is a missing s1, I would like to create a column that replaces the same row of s2 with NA. Could someone tell me?

ID s1s2
1 2 1
23 1
3 2 3
4NA2 ← I want to put the NA of s1 here
5NA2 ← I want to put the NA of s1 here

r tidyverse rstudio

2022-10-22 09:13

1 Answers

dplyr.

suppressMessages (library(dplyr))

df<-data.frame(
    ID=1:5, s1=c(2,3,2,NA,NA), s2=c(1,1,3,2,2)
)

df<-df%>%mute(s2=replace(s2,is.na(s1),NA))
df

#
  ID s1s2
1  1  2  1
2  2  3  1
3  3  2  3
44 NA
55 NA

2022-10-22 09:13

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656