R Tutorial: Mutate

Want to learn more? Take the full course at https://learn.datacamp.com/courses/data-manipulation-with-dplyr at your own pace. More than a video, you'll learn hands-on coding & quickly apply skills to your daily work. --- Datasets don't always have the variables you need. You can use the mutate() verb to add new variables or change existing variables. Let's start with a dataset that has selected four interesting variables: state, county, population, and unemployment. The unemployment rate is given as a percentage, so 5 would mean 5 percent, or one twentieth. What if you were interested in the total number of unemployed people in a county, rather than as a percentage of the population? You could use the formula population times unemployment divided by 100. You use the mutate() verb to calculate this variable and add it to the dataset as a new variable, which we'll name unemployed-underscore-population; add a pipe, then mutate, unemployed-underscore-population equals population times unemployment divided by 100. Notice that the new dataset has the variable unemployed population added to it. You got to choose the name of this variable by putting unemployed-underscore-population before the equals sign. You can combine this new variable with other verbs to ask more questions of your data. For example, what counties have the highest number of unemployed people? You'd add arrange desc unemployed-underscore-population to your mutate. In the exercises, you'll add a few new variables and answer questions based on them with the filter and arrange verbs. Let's practice! #R #RTutorial #DataCamp #Data #Manipulation #dplyr #Mutate