Skip to main content

Streamlined Data Ingestion with pandas

Learn to acquire data from common file formats and systems such as CSV files, spreadsheets, JSON, SQL databases, and APIs.

Start Course for Free
4 Hours16 Videos53 Exercises29,615 Learners
4500 XP

Create Your Free Account



By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA. You confirm you are at least 16 years old (13 if you are an authorized Classrooms user).

Loved by learners at thousands of companies

Course Description

Before you can analyze data, you first have to acquire it. This course teaches you how to build pipelines to import data kept in common storage formats. You’ll use pandas, a major Python library for analytics, to get data from a variety of sources, from spreadsheets of survey responses, to a database of public service requests, to an API for a popular review site. Along the way, you’ll learn how to fine-tune imports to get only what you need and to address issues like incorrect data types. Finally, you’ll assemble a custom dataset from a mix of sources.

  1. 1

    Importing Data from Flat Files


    Practice using pandas to get just the data you want from flat files, learn how to wrangle data types and handle errors, and look into some U.S. tax data along the way.

    Play Chapter Now
    Introduction to flat files
    50 xp
    Get data from CSVs
    100 xp
    Get data from other flat files
    100 xp
    Modifying flat file imports
    50 xp
    Import a subset of columns
    100 xp
    Import a file in chunks
    100 xp
    Handling errors and missing data
    50 xp
    Specify data types
    100 xp
    Set custom NA values
    100 xp
    Skip bad data
    100 xp
  2. 4

    Importing JSON Data and Working with APIs

    Learn how to work with JSON data and web APIs by exploring a public dataset and getting cafe recommendations from Yelp. End by learning some techniques to combine datasets once they have been loaded into data frames.

    Play Chapter Now

In the following tracks

Data Analyst Data Engineer


Adrián SotoHillary Green-Lerman
Amany Mahfouz Headshot

Amany Mahfouz

Data scientist via spatial analytics and geography.

A geographer by training, Amany drifted into data science via spatial analytics. These days, they spend a lot of time thinking about how best to structure data and streamline acquisition processes for reporting and analytics, mostly for government agencies and nonprofits. They enjoy demystifying data science and coding concepts.
See More

What do other learners have to say?

I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.

Devon Edwards Joseph
Lloyds Banking Group

DataCamp is the top resource I recommend for learning data science.

Louis Maiden
Harvard Business School

DataCamp is by far my favorite website to learn from.

Ronald Bowers
Decision Science Analytics, USAA