R replace values in one column upon matching conditions in another column

Question

I am having trouble finding a solution to this: I want to replace those NA values with some text depending on the name of the variable. Ideally it would do something like:

if variable name is var2 or var3 or var4 replace in the same row with "text"

               variable question
1               var1     <NA>
2               var2     <NA>
3               var3     <NA>
4               var4     <NA>

The closest I thought would work was:

df$question[df$variable = var2 OR var3 OR var4] <- text

it shouldn't be hard, i am just to blind to find the right answers :(.

It seems like just a syntax issue, you had the right idea. If you use the following conditional statement, it'll work: (df$variable == "var2"| df$variable == "var3" | df$variable == "var4"). Note the use of | (elementwise comparison) — Edward
– Edward, Commented Nov 24, 2013 at 14:57

flodel · Accepted Answer · 2013-11-24 15:07:30Z

4

If text is the same for var2, var3, var4 then, this should do the trick. Otherwise, if text is different for each var*, then update your question and provide us with more details.

> df$question <- as.character(df$question)
> df$question[df$variable %in% c("var2", "var3", "var4")] <- "text"
> df
  variable question
1     var1     <NA>
2     var2     text
3     var3     text
4     var4     text

edited Nov 24, 2013 at 15:07

flodel

89.3k21 gold badges190 silver badges225 bronze badges

answered Nov 24, 2013 at 14:47

Jilber Urbina

61.4k10 gold badges116 silver badges141 bronze badges

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

1 Comment

user3027387 Over a year ago

worked perfectly, thank you! It really was simple as that, similar text for all matching variables.

Collectives™ on Stack Overflow

R replace values in one column upon matching conditions in another column

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related