Data Manipulation with dplyr
Learn to transform and manipulate your data using dplyr.
Start Course for Free4 Hours13 Videos46 Exercises84,081 Learners3850 XPData Analyst TrackData Manipulation TrackData Scientist TrackR Programmer Track
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA. You confirm you are at least 16 years old (13 if you are an authorized Classrooms user).Loved by learners at thousands of companies
Course Description
Say you've found a great dataset and would like to learn more about it. How can you start to answer the questions you have about the data? You can use dplyr to answer those questions—it can also help with basic transformations of your data. You'll also learn to aggregate your data and add, remove, or change the variables. Along the way, you'll explore a dataset containing information about counties in the United States. You'll finish the course by applying these tools to the babynames dataset to explore trends of baby names in the United States.
- 1
Transforming Data with dplyr
FreeLearn verbs you can use to transform your data, including select, filter, arrange, and mutate. You'll use these functions to modify the counties dataset to view particular observations and answer questions about the data.
The counties dataset50 xpUnderstanding your data50 xpSelecting columns100 xpThe filter and arrange verbs50 xpArranging observations100 xpFiltering for conditions100 xpFiltering and arranging100 xpMutate50 xpCalculating the number of government employees100 xpCalculating the percentage of women in a county100 xpSelect, mutate, filter, and arrange100 xp - 2
Aggregating Data
Now that you know how to transform your data, you'll want to know more about how to aggregate your data to make it more interpretable. You'll learn a number of functions you can use to take many observations in your data and summarize them, including count, group_by, summarize, ungroup, and top_n.
The count verb50 xpCounting by region100 xpCounting citizens by state100 xpMutating and counting100 xpThe group by, summarize and ungroup verbs50 xpSummarizing100 xpSummarizing by state100 xpSummarizing by state and region100 xpThe top_n verb50 xpSelecting a county from each region100 xpFinding the highest-income state in each region100 xpUsing summarize, top_n, and count together100 xp - 3
Selecting and Transforming Data
Learn advanced methods to select and transform columns. Also learn about select helpers, which are functions that specify criteria for columns you want to choose, as well as the rename and transmute verbs.
Selecting50 xpSelecting columns100 xpSelect helpers100 xpThe rename verb50 xpRenaming a column after count100 xpRenaming a column as part of a select100 xpThe transmute verb50 xpChoosing among verbs50 xpUsing transmute100 xpMatching verbs to their definitions100 xpChoosing among the four verbs100 xp - 4
Case Study: The babynames Dataset
Work with a new dataset that represents the names of babies born in the United States each year. Learn how to use grouped mutates and window functions to ask and answer more complex questions about your data. And use a combination of dplyr and ggplot2 to make interesting graphs to further explore your data.
The babynames data50 xpFiltering and arranging for one year100 xpUsing top_n with babynames100 xpVisualizing names with ggplot2100 xpGrouped mutates50 xpFinding the year each name is most common100 xpAdding the total and maximum for each name100 xpVisualizing the normalized change in popularity100 xpWindow functions50 xpUsing ratios to describe the frequency of a name100 xpBiggest jumps in a name100 xpCongratulations!50 xp
Collaborators

Prerequisites
Introduction to the TidyverseDataCamp Content Creator
Course Instructor
DataCamp offers interactive R, Python, Spreadsheets, SQL and shell courses. All on topics in data science, statistics, and machine learning. Learn from a team of expert teachers in the comfort of your browser with video lessons and fun coding challenges and projects.
What do other learners have to say?
I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.
Devon Edwards Joseph
Lloyds Banking Group
DataCamp is the top resource I recommend for learning data science.
Louis Maiden
Harvard Business School
DataCamp is by far my favorite website to learn from.
Ronald Bowers
Decision Science Analytics, USAA
Join over 9 million learners and start Data Manipulation with dplyr today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA. You confirm you are at least 16 years old (13 if you are an authorized Classrooms user).