r code mutate

Sure! Here is an example of how to use the mutate() function in R, along with an explanation of each step:


# Step 1: Create a data frame
data <- data.frame(name = c("John", "Sarah", "Michael"),
                   age = c(25, 30, 35),
                   salary = c(50000, 60000, 70000))

# Step 2: Use mutate() to create a new variable
data <- mutate(data, bonus = salary * 0.1)

# Step 3: Print the updated data frame

Explanation of each step:

  1. We first create a data frame called data using the data.frame() function. This data frame contains three variables: name, age, and salary. Each variable is assigned a vector of values using the c() function.

  2. We then use the mutate() function from the dplyr package to create a new variable called bonus. In this case, we calculate the bonus as 10% of the salary by multiplying the salary variable by 0.1. The mutate() function modifies the data frame data by adding the new variable bonus to it.

  3. Finally, we print the updated data frame data to see the result. The print() function is not explicitly used here because R automatically prints the result of the last expression in the code block.

This code snippet demonstrates how to use the mutate() function in R to add a new variable to a data frame based on calculations using existing variables. By understanding and using the mutate() function, you can easily create new variables and perform data transformations in R.