Skip to main content

Course

Intermediate Importing Data in R

IntermediateSkill Level

4.8+

Updated 09/2024

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

Start Course for Free

RData Preparation3 hr10 videos48 Exercises3,950 XP82,827Statement of Accomplishment

Create Your Free Account

or

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

Loved by learners at thousands of companies

Training 2 or more people?

Try DataCamp for Business

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)

Many companies store their information in relational databases. The R community has also developed R packages to get data from these architectures. You'll learn how to connect to a database and how to retrieve data from it.

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)

Importing an entire table from a database while you might only need a tiny bit of information seems like a lot of unncessary work. In this chapter, you'll learn about SQL queries, which will help you make things more efficient by performing some computations on the database side.

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)

More and more of the information that data scientists are using resides on the web. Importing this data into R requires an understanding of the protocols used on the web. In this chapter, you'll get a crash course in HTTP and learn to perform your own HTTP requests from inside R.

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)

Importing data from the web is one thing; actually being able to extract useful information is another. Learn more about the JSON format to get one step closer to web domination.

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

Next to R, there are also other commonly used statistical software packages: SAS, STATA and SPSS. Each of them has their own file format. Learn how to use the haven and foreign packages to get them into R with remarkable ease!

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 reviewEnroll Now

Don’t just take our word for it

*4.8

from 254 reviews

85%

14%

0%

0%

0%

Sort by

Andreas

5 days ago

Damla

2 weeks ago

alexandrina

2 weeks ago

Elin

3 weeks ago

Desislava

3 weeks ago

Luiz

5 weeks ago

Andreas

alexandrina

Desislava

FAQs

What data sources does this course teach me to import into R?

You will learn to import data from relational databases, the web (including JSON APIs and HTML), and statistical software packages like SAS, STATA, and SPSS.

Should I take Introduction to Importing Data in R first?

Yes. This intermediate course assumes you already know how to import flat files and Excel data into R, which are covered in the introductory importing course.

Will I learn SQL queries as part of importing from databases?

Yes. You will learn to write SQL queries to pull only the data you need from a database, rather than importing entire tables into R unnecessarily.

Does the course cover downloading data directly from the web?

Yes. Two chapters focus on importing data from the web, including downloading files, reading JSON and HTML content, and working with APIs through the httr package.

How many exercises are included across the five chapters?

The course contains 48 exercises over five chapters, and most learners complete it in about three hours of focused study time.

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

Create Your Free Account

or

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

Grow your data skills with DataCamp for Mobile

Make progress on the go with our mobile courses and daily 5-minute coding challenges.