Serdar Balci has completed

Data Manipulation in R with dplyr

4 hours
3,400 XP

Course Description

In this interactive tutorial, you will learn how to perform sophisticated dplyr techniques to carry out your data manipulation with R. First you will master the five verbs of R data manipulation with dplyr: select, mutate, filter, arrange and summarise. Next, you will learn how you can chain your dplyr operations using the pipe operator of the magrittr package. In the final section, the focus is on practicing how to subset your data using the group_by function, and how you can access data stored outside of R in a database. All said and done, you will be familiar with data manipulation tools and techniques that will allow you to efficiently manipulate data.

.css-1goj2uy{margin-right:8px;}Group.css-gnv7tt{font-size:20px;font-weight:700;white-space:nowrap;}.css-12nwtlk{box-sizing:border-box;margin:0;min-width:0;color:#05192D;font-size:16px;line-height:1.5;font-size:20px;font-weight:700;white-space:nowrap;}Training 2 or more people?

Try DataCamp for BusinessFor a bespoke solution book a demo.
1. 1

Introduction to dplyr and tbls

Free

Introduction to the dplyr package and the tbl class. Learn the philosophy that guides dplyr, discover some useful applications of the dplyr package, and meet the data structures that dplyr uses behind the scenes.

Play Chapter Now
Section 1 - Introduction to dplyr
50 xp
Load the dplyr and hflights package
100 xp
Explore the data set
50 xp
Section 2 - tbl, a special type of data.frame
50 xp
Convert data.frame to tibble
100 xp
Changing labels of hflights, part 1 of 2
100 xp
Changing labels of hflights, part 2 of 2
100 xp
2. 2

Select and mutate

Get familiar with dplyr's manipulation verbs. Meet the five verbs and then practice using the mutate and select verbs.

3. 3

Filter and arrange

Learn how to search through the observations in your data set (and extract useful observations) with the filter function. Rearrange the observations in your data set with the arrange verb.

4. 4

Summarize and the pipe operator

Master the data manipulation verb summarize, and practice combining the five verbs to solve advanced data manipulation tasks. Learn to chain the operators together with the piping operator.

5. 5

Group_by and working with databases

Complete your mastery of data manipulation with group-wise operations and databases. Learn to use group_by to group your data into subsets of observations, and use dplyr to access data stored outside of R in a database.

GroupTraining 2 or more people?

Collaborators

Prerequisites

Introduction to RIntermediate R