O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Learning Path: R: Data Extraction, Transformation, and Loading

Video Description

Learn extraction, transformation, and loading data in R

In Detail

R needs no introduction. This Learning Path seeks to teach you all about the data ETL (Extraction, Transformation, Loading) process in R, the preferred language of choice for getting started with data science.

We first begin by learning how to get open data into R, freely available on the internet. Next, we look at extracting data from a variety of sources, such as text files, CSV files, Excel files and son on. Then we also learn about getting data from SQL databases such as MySQL into R and transforming it so that it can be processed. Finally, we learn about scraping web data and extracting it into R.

By the end of this Learning Path, you would have mastered the ETL process in R, and would be easily able to acquire and load data in R from diverse sources and begin working with it

Prerequisites: Basic knowledge of R.

Resources: Code Downloads:

  • R: Extraction, Transformation, and Loading