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