Fundamentals of R

# mutate

### Transcript

Click on the transcript to go to that point in the video. Please note that transcripts are auto generated and may contain minor inaccuracies.

Complete the mutate sections of the data-wrangling-and-analysis-exercises.Rmd file.

General Data Wrangling and Analysis Resources

Because most material that discusses data wrangling and analysis with the dplyr packges does so in a way that covers all of the verbs discussed in this course, I have chosen not to separate them by lesson. Instead, here are some helpful resources for learning more about all of the tidyverse verbs discussed in this course:

Chapter 5 of R for Data Science

RStudio Cloud primer on working with data

Tidyverse for Beginners by Danielle Navarro

Learning Statistics with R by Danielle Navarro

Introduction to the Tidyverse by Alison Hill

A gRadual intRoduction to data wRangling by Chester Ismay and Ted Laderas

Working in the Tidyverse by Desi Quintans and Jeff Powell

Christine Monnier video tutorials on dplyr

## Have any questions? Put them below and we will help you out!

You need to be signed-in to comment on this post. Login.

#### Bohdanna Kinasevych • March 27, 2021

how do I add multiple columns together to create a new variable without having to write out each existing variable in the mutate function. For example if I have 10 questions on a survey and I want to create a composite score based on a sum of these 10 questions, is there a way to do this without having to write out: var1 + var2 + var3 .... + var10?

#### Eduardo Rodriguez • March 30, 2021

Hi David, how do I change a value format? For example, in the course assignment we divide by 30 and get a long decimal value. How would I format it so that it only shows two decimal places or even, out of curiosity, as a percentage?

#### Harold Stanislaw • March 31, 2021

Question regarding overwriting a variable with itself. I'm always nervous about doing this, in case I mess up. On the other hand, I can see where creating new variables and keeping the old ones can easily get out of hand and/or require using the drop pipe a lot. If I want to overwrite a variable onto itself is there an easy way to undo the mutate if I make a mistake?

#### Lina Khan • September 27, 2021

When the values are changed, like rounding values, how come it doesn't show in the dataset tab? Or, have I forgotten something? For example, the output still shows the rounded values when I select the variable. But other than clean_names, the changes don't appear in the dataset. Thanks!

#### David Keyes Founder • September 28, 2021

I typically keep both a numeric and a character variable. Here's a quick explanation of why.

#### Lindsay Quarles • October 21, 2021

Can you help me better understand the round function? I don't understand the digits part? Does it only apply to decimals? What if you want to round to the nearest whole number what would you put? Or to round to the nearest 10?

#### Yenn Lee • July 19, 2022

Hi, I have a column that I would like to split into three. The data in the existing column looks like the following, and I would like it to feed into three new columns: id, bio, and username.