Skip to main content
HomeReportingStreamlined Data Ingestion with pandas

Streamlined Data Ingestion with pandas

4.5+
12 reviews
Intermediate

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 Exercises
48,162 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.

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

    Free

    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 Engineer in Python

Collaborators

Collaborator's avatar
Hillary Green-Lerman
Collaborator's avatar
Adrián Soto
Amany Mahfouz HeadshotAmany Mahfouz

Data scientist via spatial analytics and geography.

See More

Don’t just take our word for it

*4.5
from 12 reviews
83%
8%
0%
0%
8%
Sort by
  • Faria C.
    about 1 month

    This course has many useful tips for handling type conversions such as datetimes and booleans. The chapter on parsing nested JSON from an API is very helpful, and I have already put it to use.

  • Lorenzo A.
    2 months

    Good

  • Sorin I.
    11 months

    Great content and practice mode. Concise and easy to follow, very useful.

  • Victor G.
    12 months

    Excellent course

  • Erick S.
    about 1 year

    Quite fluid course, straight to the point, clear examples.

"This course has many useful tips for handling type conversions such as datetimes and booleans. The chapter on parsing nested JSON from an API is very helpful, and I have already put it to use."

Faria C.

"Good"

Lorenzo A.

"Great content and practice mode. Concise and easy to follow, very useful."

Sorin I.

Join over 13 million learners and start Streamlined Data Ingestion with pandas 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.