Advanced pandas—Going Beyond the Basics

Intermediate

94 Lessons

16h

Certificate of Completion

AI-POWERED

Explanations

This course includes

584 Playgrounds

10 Quizzes

80 Illustrations

This course includes

584 Playgrounds

10 Quizzes

80 Illustrations

Course Overview

Pandas is an easy-to-use and performant Python library for data manipulation and analysis. It is an important toolkit in a world where the volume of data created and captured is growing exponentially. In this course, you’ll discover an in-depth exploration of the pandas library. The course covers advanced techniques to reshape data, manipulate data, and handle various data types. You will also learn how to use less conventional pandas features to streamline workflows, while also leveraging extended pandas...Show More

TAKEAWAY SKILLS

Python

Data Manipulation

Data Plotting

Data Extraction

Data Statistics

Data Science

Analysis Tools

Python 3

Data Collection

Data Cleaning

Data Visualisation

Data Analysis

Data Types

Python Programming

Polars

Time Series Analysis

Data Storytelling

What You'll Learn

Understanding of pandas’ extensive capabilities in reading data from different sources

Working knowledge of how to effectively handle different types of data in pandas

Hands-on experience using data reshaping and manipulation techniques in pandas

Ability to leverage extended pandas libraries for advanced capabilities in handling and analyzing data

Familiarity with less conventional yet useful features of pandas

Knowledge of efficiency boosting techniques

Course Content

Before We Begin

Course Introduction

Reading Data into pandas

Importance of Data Ingestion

Read Data from the Web

Read Data from HTML Files Read Data from XML Files Read Data from Statistical Software Files Read Data from SQL Databases Read Data from Binary Files (Feather, HDF5, ORC, Parquet)Quiz

Combining Data

Importance of Combining Data Concatenate Merging—Types of Joins Merge 2—Implementation Merging—Scenarios Combine and Update Quiz

Reshaping and Manipulating Data

Importance of Reshaping and Manipulating Data GroupBy—The groupby() method GroupBy—Aggregate GroupBy—Transform and Filter GroupBy—Further Useful Features Pivot—Long and Wide Formats Pivot—The pivot() method Unpivot Stack and Unstack Further Reshaping Capabilities Advanced Indexing 1 Advanced Indexing 2 Quiz

Encoding Data Types

Inspect Data Types Convert and Encode Data Types

Handling Numerical Data

10 Lessons

Handling Categorical Data

6 Lessons

Handling Text Data

7 Lessons

Handling Time Series Data

17 Lessons

Handling Sparse Data Structures

2 Lessons

Handling Missing Data

4 Lessons

Leveraging Further Features of pandas

6 Lessons

Utilizing Extended Libraries

5 Lessons

Wrap Up

1 Lesson

Appendix

5 Lessons

COURSE AUTHOR

How You'll Learn

You don’t get better at swimming by watching others. Coding is no different. Practice as you learn with live code environments inside your browser.

Videos are holding you back. Educative‘s interactive, text-based lessons accelerate learning — no setup, downloads, or alt-tabbing required.

Learn faster and smarter with adaptive AI tools embedded in every Educative course.

Built-in assessments let you test your skills. Completion certificates let you show them off.

Recommended Courses

BEFORE STARTING THIS COURSE

AFTER FINISHING THIS COURSE

FOR TEAMS

Interested in this course for your business or team?

Unlock this course (and 1,000+ more) for your entire org with DevPath