(Old) 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.

Unavailable
(Old) 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 an 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 have a dog named Coog (Lllasa Apso)., I work as a Data Analyst/Financial Analyst for a Metals Co. located in Seattle, WA. I have been in my current position for 5 years. I work in SQL, R, R Shiny, QGIS. Because I have traveled the roads you are on I believe I will be an asset and will add value to your programming repertoire. We will walk through multiple examples and get to know each other through the process. Don't take my word for it though. Come on in and take a Project or two. Regards, Chris Shockley



Frequently Asked Questions


In Rhyme, all projects 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 projects. 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 projects 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
Rhyme's visual instructions are somewhat helpful for reading impairments. The Rhyme interface has features like resolution and zoom that are slightly helpful for visual impairment. And, we are currently developing a close-caption functionality to help with hearing impairment. Most of the accessibility options of the cloud desktop's operating system or the specific application can also be used in Rhyme. However, we still have a lot of work to do. If you have suggestions for accessibility, please email us at accessibility@rhyme.com
We started with windows and linux cloud desktops because they have the most flexibility in teaching any software (desktop or web). However, web applications like Salesforce can run directly through a virtual browser. And, others like Jupyter and RStudio can run on containers and be accessed by virtual browsers. We are currently working on such features where such web applications won't need to run through cloud desktops. But, the rest of the Rhyme learning, authoring, and monitoring interfaces will remain the same.
Please email us at help@rhyme.com and we'll respond to you within one business day.

No sessions available