Data Manipulation with dplyr
Build Tidyverse skills by learning how to transform and manipulate data with dplyr.
Start Course for Free4 hours13 videos44 exercises143,159 learnersStatement of Accomplishment
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.Training 2 or more people?
Try DataCamp for BusinessLoved 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? Use dplyr to answer those questions.
First, explore fundamental data transformation techniques, including the use of key dplyr verbs like select, filter, arrange, and mutate. These functions will teach you how to modify datasets by selecting specific columns, filtering rows based on conditions, sorting data, and creating new calculated columns.
You’ll understand how to make your data more interpretable and manageable. Functions such as count, group_by, and summarize are introduced to perform operations that aggregate many observations into meaningful summaries, essential for data analysis and reporting.
By the end of the course, you will have developed robust data manipulation skills using dplyr, enabling more efficient and effective data analysis—a vital capability for any data analyst or scientist.
First steps: Transforming data with dplyr
This course is designed to teach users how to efficiently manipulate and transform data using the dplyr package in R.First, explore fundamental data transformation techniques, including the use of key dplyr verbs like select, filter, arrange, and mutate. These functions will teach you how to modify datasets by selecting specific columns, filtering rows based on conditions, sorting data, and creating new calculated columns.
Aggregating data with dplyr
Next, the course covers data aggregation, teaching users how to summarize and condense data for better interpretation.You’ll understand how to make your data more interpretable and manageable. Functions such as count, group_by, and summarize are introduced to perform operations that aggregate many observations into meaningful summaries, essential for data analysis and reporting.
Selecting and transforming data
Finally, you will learn advanced data selection and transformation techniques, such as using select helpers and the rename verb. You will also get to apply your skills to a real-world case study and practice grouped mutates, window functions, and data visualization with ggplot2.By the end of the course, you will have developed robust data manipulation skills using dplyr, enabling more efficient and effective data analysis—a vital capability for any data analyst or scientist.
Training 2 or more people?
Get your team access to the full DataCamp platform, including all the features.In the following Tracks
Data Manipulation in R
Go To Track- 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.
Exploring data with dplyr50 xpUnderstanding your data50 xpSelecting columns100 xpThe filter and arrange verbs50 xpArranging observations100 xpFiltering for conditions100 xpFiltering and arranging100 xpThe mutate() verb50 xpCalculating the number of government employees100 xpCalculating the percentage of women in a county100 xpMutate, 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 slice_min/slice_max.
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 slice_min and slice_max verbs50 xpSelecting a county from each region100 xpFinding the lowest-income state in each region100 xpUsing summarize, slice_max, 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 verb.
- 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 xpFinding the most popular names each year100 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
Training 2 or more people?
Get your team access to the full DataCamp platform, including all the features.In the following Tracks
Data Manipulation in R
Go To TrackJames Chapman
See MoreData Science & AI Curriculum Manager, DataCamp
James is a Curriculum Manager at DataCamp, where he collaborates with experts from industry and academia to create courses on AI, data science, and analytics. He has led nine DataCamp courses on diverse topics in Python, R, AI developer tooling, and Google Sheets. He has a Master's degree in Physics and Astronomy from Durham University, where he specialized in high-redshift quasar detection. In his spare time, he enjoys restoring retro toys and electronics.
Follow James on LinkedIn
Follow James on LinkedIn
FAQs
Join over 15 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.