Home>
Courses>
Advance Pandas Going Beyond The Basics

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
What You'll Learn
Course Content

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

See more

Course Content

1

Before We Begin

Course Introduction
2

Reading Data into pandas

Importance of Data Ingestion
Read Data from the Web
Read Data from HTML FilesRead Data from XML FilesRead Data from Statistical Software FilesRead Data from SQL DatabasesRead Data from Binary Files (Feather, HDF5, ORC, Parquet)Quiz
3

Combining Data

Importance of Combining DataConcatenateMerging—Types of JoinsMerge 2—ImplementationMerging—ScenariosCombine and UpdateQuiz
4

Reshaping and Manipulating Data

Importance of Reshaping and Manipulating DataGroupBy—The groupby() methodGroupBy—AggregateGroupBy—Transform and FilterGroupBy—Further Useful FeaturesPivot—Long and Wide FormatsPivot—The pivot() methodUnpivotStack and UnstackFurther Reshaping CapabilitiesAdvanced Indexing 1Advanced Indexing 2Quiz
5

Encoding Data Types

Inspect Data TypesConvert and Encode Data Types
6

Handling Numerical Data

10 Lessons

7

Handling Categorical Data

6 Lessons

8

Handling Text Data

7 Lessons

9

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

Practice and apply your skills

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

Adaptive Learning

Explain with AI

AI Code Mentor

Looking for something else?

FOR TEAMS

Interested in this course for your business or team?

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