Streamlined Data Ingestion with pandas

DataCamp

(3)

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

Before you can analyze the data, you need to first acquire it. This course will show you how to build pipelines to import data from common storage formats. Pandas, a Python library specializing in analytics, can be used to extract data. This can include spreadsheets of survey responses that are linked to a database of public service requests. Learn how to modify imports and fix problems such as incorrect data types. Learn how to create custom data sets from various sources.

Course Overview

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Intermediate Python

Introduction to SQL

What You Will Learn

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

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

You’ll assemble a custom dataset from a mix of sources

Course Content

Expand all sections

Module 1: Importing Data from Flat Files

Module 2: Importing Data From Excel Files

Module 3: Importing Data from Databases

Module 4: Importing JSON Data and Working with APIs

Course Instructors

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 fo...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%