Data Analysis with R: Introduction to dplyr

In this tutorial you will learn Hadley Wickham’s dplyr package. The six basic verbs are the syntax that will allow you to manipulate your data quick and seamlessly.
Learning dplyr is like learning the violin but it doesn’t take 5 years. It only takes 2 weeks. Take this tutorial and my ‘More Dplyr’ course and practice for two weeks and you will be a data manipulation wizard.

Start for Free
First 2 tasks free. Then, decide to pay $9.99 for the rest
Data Analysis with R: Introduction to dplyr

Duration (mins)

Learners

5.0 / 5

Rating

Task List


We will cover the following tasks in 34 minutes:


Introduction

There is a great cheat sheet. It’s on RStudio’s website. In this section I will show you where it is and we will go over some of the common functions. After that I’ll show you Rhyme’s amazing Interface and then I’ll give you a quick bio about me. I’ll see you when you get in.


Select

In excel we hide columns we delete columns we cut and past columns. In R using dplyr and the verb select we create new data frames with a simple call with only the columns we need. This is really cool. But don’t take my word for it. Come in and experiment for yourself.


Filter

In excel we hide rows and cut them and paste them. We use filters to filter the rows. Well in R. It’s as simple as using the verb Filter. When using this filter with Boolean logic we can create data frames with only the data we want. This function combined with Select gives you a lot of control over your data. Instead of hiding things you have your main data frame and sub data frames based on the criteria you want. After this is done, if you so choose, you can write the dataframes to excel using the write.csv function.


Piping Operator

The Pipe. This is something Hadley Wickham borrowed from the Maggitr package. From now on when you hear pipe think glue. Using this glue we can paste our functions together seamlessly. This has a couple of side effects. One is that the code is easy to read. Others code is easier to read. Also, creating sub data frames is easy as is visualizing what you want your data frame to look like - even before you start writing the code. Awesome.


Arrange

So you want to arrange your data alphabetically? Numerically? How about two different columns? Arrange is your function. This doesn’t have the same magical effects as Select and Filter but it does serve its purpose. Come in and I will show you how to its used.


Summarise

This is my favorite. Think pivot table in Excel on steroids. I’ll walk you through its magic. By the way, this lesson is a two’fer since I will throw in the group_by function as well. Join me and I’ll show you all about this wicked verb combo.


Mutate

So you want to create some more variables for feature engineering or you want the percentages of a few different columns or you want the mean and standard deviation. With Mutate this is a breeze. Come in and I’ll show you how this works.


Final Thoughts

You have completed the Intro to Dplyr. By this point you are seeing the power of dplyr and R. But. You must practice. Everyday for two weeks. I promise after that you’ll be doing data hand springs through your data manipulation problems.

Watch Preview

Preview the instructions that you will follow along in a hands on session in your browser.

Chris Shockley

About the Host (Chris Shockley)


I am a R enthusiast, hiker, and amateur astronomer. My favorite hike is located in Mt. Rainier National Park, my favorite Deep Sky Object is Alberio, and my favorite R package is dplyr (since I use it everyday). I am single too. Maybe because I spend too much time playing? I have a dog named Coog (Lllasa Apso), who would rather be outside than inside, which means I have to take him on a lot of walks. I work as a Data Analyst/Financial Analyst for a Metals Co. located in Seattle, WA. I have been in my current position for 4 years. My hope is that I can help you, even if its with my enthusiasm. Yes you can learn R and the Rhyme Interface will help you. But. You also must take what you learn and practice, practice, practice. So... Let's get after it. See you soon.



Frequently Asked Questions


In Rhyme, all sessions are completely hands on. You don't just passively watch someone else. You use the software directly while following the host's (Chris Shockley) instructions. Using the software is the only way to achieve mastery. With the "Live Guide" option, you can ask for help and get immediate response.
Nothing! Just join through your web browser. Your host (Chris Shockley) has already installed all required software and configured all data.
You can go to https://rhyme.com/for-companies, sign up for free, and follow this visual guide How to use Rhyme to create your own sessions. If you have custom needs or company-specific environment, please email us at help@rhyme.com
Absolutely. We offer Rhyme for workgroups as well larger departments and companies. Universities, academies, and bootcamps can also buy Rhyme for their settings. You can select sessions and trainings that are mission critical for you and, as well, author your own that reflect your own needs and tech environments. Please email us at help@rhyme.com
Please email us at help@rhyme.com and we'll respond to you within one business day.

First 2 tasks free. Then, decide to pay $9.99 for the rest