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 Free4 hours16 videos53 exercises52,206 learnersStatement 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.Training 2 or more people?
Try DataCamp for BusinessLoved 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.
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreIn the following Tracks
- 1
Importing Data from Flat Files
FreePractice 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.
Introduction to spreadsheets50 xpGet data from a spreadsheet100 xpLoad a portion of a spreadsheet100 xpGetting data from multiple worksheets50 xpSelect a single sheet100 xpSelect multiple sheets100 xpWork with multiple spreadsheets100 xpModifying imports: true/false data50 xpSet Boolean columns100 xpSet custom true/false values100 xpModifying imports: parsing dates50 xpParse simple dates100 xpGet datetimes from multiple columns100 xpParse non-standard date formats100 xp - 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.
Introduction to databases50 xpConnect to a database100 xpLoad entire tables100 xpRefining imports with SQL queries50 xpSelecting columns with SQL100 xpSelecting rows100 xpFiltering on multiple conditions100 xpMore complex SQL queries50 xpGetting distinct values100 xpCounting in groups100 xpWorking with aggregate functions100 xpLoading multiple tables with joins50 xpJoining tables100 xpJoining and filtering100 xpJoining, filtering, and aggregating100 xp - 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.
Introduction to JSON50 xpLoad JSON data100 xpWork with JSON orientations100 xpIntroduction to APIs50 xpGet data from an API100 xpSet API parameters100 xpSet request headers100 xpWorking with nested JSONs50 xpFlatten nested JSONs100 xpHandle deeply nested data100 xpCombining multiple datasets50 xpConcatenate dataframes100 xpMerge dataframes100 xpWrap-up50 xp
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreIn the following Tracks
datasets
Vermont tax return data by ZIP codeFreeCodeCamp New Developer Survey response subsetNYC weather and 311 housing complaintscollaborators
Amany Mahfouz
See MoreData scientist via spatial analytics and geography.
Join over 14 million learners and start Streamlined Data Ingestion with pandas 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.