Advanced pandas—Going Beyond the Basics

Intermediate

94 Lessons

16h

Certificate of Completion

AI-POWERED

Explanations

AI-POWERED

Explanations

This course includes

584 Playgrounds

10 Quizzes

This course includes

584 Playgrounds

10 Quizzes

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

What You'll Learn

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

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

10.

Handling Sparse Data Structures

2 Lessons

11.

Handling Missing Data

4 Lessons

12.

Leveraging Further Features of pandas

6 Lessons

13.

Utilizing Extended Libraries

5 Lessons

14.

Wrap Up

1 Lesson

15.

Appendix

5 Lessons

Course Author

Trusted by 1.4 million developers working at companies

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Evan Dunbar

ML Engineer

Carlos Matias La Borde

Software Developer

Souvik Kundu

Front-end Developer

Vinay Krishnaiah

Software Developer

Eric Downs

Musician/Entrepeneur

Kenan Eyvazov

DevOps Engineer

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Hands-on Learning Powered by AI

See how Educative uses AI to make your learning more immersive than ever before.

Instant Code Feedback

Evaluate and debug your code with the click of a button. Get real-time feedback on test cases, including time and space complexity of your solutions.

AI-Powered Mock Interviews

Put your skills to the test in a simulated interview setting. Receive personalized feedback based on your performance. Available in Premium & Premium Plus plans.

Adaptive Learning

At various checkpoints throughout Educative courses, you will be prompted to take a quick assessment. Receive a condensed curriculum tailored to your strengths and skill gaps.

Explain with AI

Select any text within any Educative course, and get an instant explanation — without ever leaving your browser.

AI Code Mentor

AI Code Mentor helps you quickly identify errors in your code, learn from your mistakes, and nudge you in the right direction — just like a 1:1 tutor!