R Data Pre-Processing & Data Management - Shape your Data!
4.3 (481 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,391 students enrolled

R Data Pre-Processing & Data Management - Shape your Data!

Learn how to prepare your data for great analytics in R.
4.3 (481 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,391 students enrolled
Last updated 11/2018
English [Auto]
Current price: $76.99 Original price: $109.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6 hours on-demand video
  • 14 articles
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • import data into R in several ways while also beeing able to identify a suitable import tool
  • select and implement a proper object class (data.frame, data.table, data_frame)
  • convert your data into (and understand) a tidy data format
  • filter and query your data based on a wide range of parameters
  • join 2 data tables together with dplyr 2 table verb syntax
  • use SQL code within R
  • translate basic R into SQL
  • work with dates and time
  • work with strings using regular expressions
  • detecting outliers in datasets
Course content
Expand all 64 lectures 06:25:39
+ Introduction
5 lectures 46:32
Data Pre-Processing as Integral Part of Data Science
Let's See an R Example of Data Pre-Processing
Lures Example Script
+ Data Import and Data Structuring
5 lectures 35:10
Script: Data import
Importing Data and Snippets
Using fread to handle big data fast
Choosing the right class for your data
Further R Exercises
+ Cleaning Your Data
5 lectures 21:51
Script: Data cleaning
tidyr - How tidy data looks like
Wide to long data format
Splitting columns
Long to wide data format
+ Querying and Filtering Data with data.table
9 lectures 51:37
Script: Querying with data.table
What is data.table?
Basic queries
The by paramater for queries
Update on recycle queries
Data.table exercises
Data.table solutions
+ Queries and Filtering Exercises
9 lectures 01:22:37
Query exercises INTRO
10 Exercises on 'data.frame'
Data.frame Exercise Script
Data.frame Solutions 1-4
Data.frame Solutions 5-10
10 Exercises on 'data.table'
Data.table Exercise Script
Data.table Solutions 1-4
Data.table Solutions 5 - 10
+ Using dplyr on one and multiple Datasets
5 lectures 31:18
Script: dplyr
Single Table Verbs in 'dplyr'
Two Table Verbs - Mutating Joins
Two Table Verbs - Filtering Joins and handling of ID mismatches
+ Integrate SQL into R
5 lectures 18:47
Script: Integrate SQL
Get package dbplyr
R to SQL Translator
Set Up a SQLite Database in R
+ Detecting Outliers
4 lectures 26:17
Outlier Script
Introduction to Outlier Detection
Detecting Outliers in Univariate Datasets
Detecting Outliers in Multivariate Datasets
+ Working with Strings - Regular Expressions
7 lectures 29:33
Script: Working with Strings
Regular Expressions and Gsub
What You Should Know about Strings in R
The Gsub Family of Functions and Regular Expressions
Regular Expressions Syntax
A Great Add On Package
Working with Strings in R: Exercise with Solution
+ Working with Dates and Time
10 lectures 41:52
Data management and time series INTRO
Importing a Time Series From Excel
Section Script
Classes POSIXt, Date and Chron
Lubridate: Input and Time Zones
Lubridate: Weekdays and Intervals
Lubridate: Exercise Data Frame
Lubridate: Calculations and Leap Years
Lubridate: Data Handling Exercise
Further R Exercises
  • Computer with R and RStudio ready to use
  • You should have basic R / RStudio knowledge
  • Required add on packages will be listed in the course orientation video

Let’s get your data in shape!

Data Pre-Processing is the very first step in data analytics. You cannot escape it, it is too important. Unfortunately this topic is widely overlooked and information is hard to find.

With this course I will change this!

Data Pre-Processing as taught in this course has the following steps:

1.       Data Import: this might sound trivial but if you consider all the different data formats out there you can imagine that this can be confusing. In the course we will take a look at a standard way of importing csv files, we will learn about the very fast fread method and I will show you what you can do if you have more exotic file formats to handle.

2.       Selecting the object class: a standard data.frame might be fine for easy standard tasks, but there are more advanced classes out there like the data.table. Especially with those huge datasets nowadays, a data.frame might not do it anymore. Alternatives will be demonstrated in this course.

3.       Getting your data in a tidy form: a tidy dataset has 1 row for each observation and 1 column for each variable. This might sound trivial, but in your daily work you will find instances where this simple rule is not followed. Often times you will not even notice that the dataset is not tidy in its layout. We will learn how tidyr can help you in getting your data into a clean and tidy format.

4.       Querying and filtering: when you have a huge dataset you need to filter for the desired parameters. We will learn about the combination of parameters and implementation of advanced filtering methods. Especially data.table has proven effective for that sort of querying on huge datasets, therefore we will focus on this package in the querying section.

5.       Data joins: when your data is spread over 2 different tables but you want to join them together based on given criteria, you will need joins for that. There are several methods of data joins in R, but here we will take a look at dplyr and the 2 table verbs which are such a great tool to work with 2 tables at the same time.

6.       Integrating and interacting with SQL: R is great at interacting with SQL. And SQL is of course the leading database language, which you will have to learn sooner or later as a data scientist. I will show you how to use SQL code within R and there is even a R to SQL translator for standard R code. And we will set up a SQLite database from within R. 

7.  Outlier detection: Datasets often contain values outside a plausible range. Faulty data generation or entry happens regularly. Statistical methods of outlier detection help to identify these values. We will take a look at the implemention of these.

8. Character strings as well as dates and time have their own rules when it comes to pre-processing. In this course we will also take a look at these types of data and how to effectively handle it in R.

How do you best prepare yourself for this course?

You only need a basic knowledge of R to fully benefit from this course. Once you know the basics of RStudio and R you are ready to follow along with the course material. Of course you will also get the R scripts which makes it even easier.

The screencasts are made in RStudio so you should get this program on top of R. Add on packages required are listed in the course.

Again, if you want to make sure that you have proper data with a tidy format, take a look at this course. It will make your analytics with R much easier!

Who this course is for:
  • Data pre-processing is a crucial step of data related work - therefore this course is intended for all R users