Interactive Course

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.

  • 4 hours
  • 16 Videos
  • 53 Exercises
  • 1,831 Participants
  • 4,500 XP

Loved by learners at thousands of top companies:

intel-grey.svg
rei-grey.svg
paypal-grey.svg
deloitte-grey.svg
roche-grey.svg
forrester-grey.svg

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.

  2. Importing Data From Excel Files

    Automate data imports from that staple of office life, Excel files. Import part or all of a workbook and ensure boolean and datetime data are properly loaded, all while learning about how other people are learning to code.

  3. Importing Data from Databases

    Combine pandas with the powers of SQL to find out just how many problems New Yorkers have with their housing. This chapter features introductory SQL topics like WHERE clauses, aggregate functions, and basic joins.

  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.

What do other learners have to say?

Devon

“I've used other sites, but DataCamp's been the one that I've stuck with.”

Devon Edwards Joseph

Lloyd's Banking Group

Louis

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

Louis Maiden

Harvard Business School

Ronbowers

“DataCamp is by far my favorite website to learn from.”

Ronald Bowers

Decision Science Analytics @ USAA

Amany Mahfouz
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
Icon Icon Icon professional info