I'm having a problem with a set of data. I want to change the values of a column, only for certain values in the rows of data. My table has this structure:
Var1 Var2
1 A High
2 A High
3 A High
4 B High
5 B High
6 B High
7 C High
8 C Low
9 C Low
10 C Low
Now, I want to change the "Var2" values to "Medium", only when Var 1 is C. Thank you for help! :) Alin.
Method 1: Using Replace() function. replace() function in R Language is used to replace the values in the specified string vector x with indices given in list by those given in values.
Use R dplyr::coalesce() to replace NA with 0 on multiple dataframe columns by column name and dplyr::mutate_at() method to replace by column name and index. tidyr:replace_na() to replace.
Assuming d
is your data.frame:
d$Var2[d$Var1 == "C"] <- "Medium"
try
d$Var2[d$Var1 == "C", ] <- "Medium"
There has to be a comma after the condition. This is a R-specific thing.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With