Skip to main content
HomeRIntermediate Importing Data in R

Intermediate Importing Data in R

4.8+
11 reviews
Intermediate

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

Start Course for Free
3 hours10 videos48 exercises
79,321 learnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
GroupTraining 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.
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

Certification Available

Data Scientist in R

Go To Track

Importing & Cleaning Data in R

Go To Track
  1. 1

    Importing data from databases (Part 1)

    Free

    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.

    Play Chapter Now
    Connect to a database
    50 xp
    Establish a connection
    100 xp
    Inspect the connection
    50 xp
    Import table data
    50 xp
    List the database tables
    100 xp
    Import users
    100 xp
    Import all tables
    100 xp
    How do the tables relate?
    50 xp
  2. 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.

    Play Chapter Now
  3. 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.

    Play Chapter Now
  4. 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.

    Play Chapter Now
  5. 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!

    Play Chapter Now
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

In the following Tracks

Certification Available

Data Scientist in R

Go To Track

Importing & Cleaning Data in R

Go To Track

datasets

Education equality dataEmployee dataFlorida election dataInternational socio-economic dataLatitude (XLS)Latitude (XLSX)Big Five dataPotatoesSales dataSwimming poolsSugar import dataWater dataWine data
Filip Schouwenaars HeadshotFilip Schouwenaars

Data Science Instructor at DataCamp

Filip is the passionate developer behind several of DataCamp's most popular Python, SQL, and R courses. Currently, Filip leads the development of DataCamp Workspace, a collaborative data science notebook. Under the motto 'Eat your own dog food', he uses Workspace to understand how users learn on and interact with DataCamp. Filip holds degrees in Electrical Engineering and Artificial Intelligence.
See More

Don’t just take our word for it

*4.8
from 11 reviews
91%
0%
9%
0%
0%
Sort by
  • Richmond A.
    28 days

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

  • James K.
    8 months

    Excellent

  • Christopher L.
    about 1 year

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

  • Paula S.
    over 1 year

    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.
    over 1 year

    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 14 million learners and start Intermediate Importing Data in R today!

Create Your Free Account

GoogleLinkedInFacebook

or

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