Skip to main content

course

Intermediate Importing Data in R

Intermediate

4.8+

Updated 12/2024

Parse data in any format. Whether it's flat files, statistical software, databases, or data right from the web.

Start course for free

Included for FreePremium or Teams

RData Preparation3 hours10 videos48 exercises3,950 XP79,922Statement of Accomplishment

Create Your Free Account

Google LinkedIn Facebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

In this course, you will take a deeper dive into the wide range of data formats out there. More specifically, you'll learn how to import data from relational databases and how to import and work with data coming from the web. Finally, you'll get hands-on experience with importing data from statistical software packages such as SAS, STATA, and SPSS.

Prerequisites

Introduction to Importing Data in R

1

Importing data from databases (Part 1)

Connect to a database

Establish a connection

Inspect the connection

Import table data

List the database tables

Import users

Import all tables

How do the tables relate?

2

Importing data from databases (Part 2)

SQL Queries from inside R

Query tweater (1)

Query tweater (2)

Query tweater (3)

Query tweater (4)

Join the query madness!

DBI internals

Send - Fetch - Clear

Be polite and ...

3

Importing data from the web (Part 1)

HTTP

Import flat files from the web

Secure importing

Downloading files

Import Excel files from the web

Downloading any file, secure or not

Reading a text file from the web

HTTP? httr! (1)

HTTP? httr! (2)

4

Importing data from the web (Part 2)

APIs & JSON

From JSON to R

Import JSON data from API

JSON & jsonlite

JSON practice (1)

JSON practice (2)

Minify and prettify

5

Importing data from statistical software packages

Import SAS data with haven

Import STATA data with haven

What does the graphic tell?

Import SPSS data with haven

Factorize, round two

Import STATA data with foreign (1)

Import STATA data with foreign (2)

Do you know your data?

Import SPSS data with foreign (1)

Excursion: Correlation

Import SPSS data with foreign (2)

Intermediate Importing Data in R

Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Don’t just take our word for it

*4.8

from 11 reviews

91%

0%

9%

0%

0%

Highest to Lowest
Lowest to Highest
Most recent
Top reviews

Richmond A.

4 months

Comprise everything one needs to know about importing data from different sources to R.

James K.

10 months

Excellent

Christopher L.

over 1 year

The content of the course was superb as well as the mode of delivery with examples and exercises!

Paula S.

almost 2 years

Filip Schouwenaars is a great teacher. The small video on the side really helps me maintain focus and follow his train of thought. The choice of material is well rounded and the descriptions in the exercises are easy to follow without giving the answer away. This applies to all of Filip's courses I have done so far. Chapeau!

Nicolas F.

almost 2 years

This course helps greatly with learning efficient ways to run importing functions in R.

"Comprise everything one needs to know about importing data from different sources to R."

Richmond A.

"Excellent"

James K.

"The content of the course was superb as well as the mode of delivery with examples and exercises!"

Christopher L.

Join over 15 million learners and start Intermediate Importing Data in R today!

Create Your Free Account

Google LinkedIn Facebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.