Data Wrangling with Python

Standard Course
Fundamental
Fully Ready

About the Course

This course teaches essential data manipulation skills using Python libraries like Pandas and NumPy. You’ll learn to read, reshape, filter, group, and clean data — preparing it for analysis. By the end, you’ll be able to transform real-world datasets to solve practical business problems.

Learning Outcomes

By the end of this course, participants will be able to:

  • Work with Pandas Series, DataFrames, and Index objects
  • Read, write, filter, and transform structured data using Pandas
  • Clean data to ensure quality and integrity, including handling missing values and outliers
  • Reshape, pivot, and organize data for effective analysis
  • Merge, join, and group datasets using core data manipulation techniques
  • Apply data wrangling skills to real-world problems through hands-on projects

Curriculum

  • Chapter 1: Intro to Pandas Data Structures

    Overview:

    In this chapter, participants will be introduced to the Pandas library, the foundation of data wrangling in Python. They will learn how to create and manipulate Series and DataFrames, and gain an understanding of Pandas indexing.

    Topics to Cover:

    • Diving into Pandas Series
    • Creating and working with Pandas DataFrames
    • Understanding Pandas Index

  • Chapter 2: Essential Functionality

    Overview:

    In this chapter, participants will explore Pandas’ essential functionality for data handling. They will practice reindexing, dropping data, filtering with conditions, and applying functions to transform datasets.

    Topics to Cover:

    • Reindexing and dropping data
    • Selecting and filtering data by conditions
    • Applying functions and mapping

  • Chapter 3: Reading and Writing Data

    Overview:

    In this chapter, participants will learn how to read and write data in different formats. They will gain experience working with common file types and understand how to integrate external data into Pandas workflows.

    Topics to Cover:

    • Reading and writing data
    • Dealing with common types of data files (CSV, Excel, JSON, etc.)
    • Learning relevant I/O methods

  • Chapter 4: Reshaping and Pivoting Data

    Overview:

    In this chapter, participants will reshape datasets for better analysis and visualization. They will work with hierarchical indexing and practice converting data between long and wide formats.

    Topics to Cover:

    • Reshaping with hierarchical indexing
    • Changing long format to wide format

  • Chapter 5: Data Transformation

    Overview:

    In this chapter, participants will clean and transform data using Pandas functions. They will handle duplicates, replace values, categorize data, and address outliers to prepare datasets for analysis.

    Topics to Cover:

    • Removing duplicate values
    • Transforming data using functions and mapping
    • Replacing values and categorizing data
    • Dealing with outliers

  • Chapter 6: String Manipulation

    Overview:

    In this chapter, participants will learn how to work with text data in Pandas. They will explore common string operations, use vectorized string functions, and get introduced to regular expressions for advanced string processing.

    Topics to Cover:

    • Common string operations and object methods
    • Introduction to regular expressions
    • Vectorized string functions in Pandas

  • Chapter 7: Combining & Merging Datasets

    Overview:

    In this chapter, participants will combine datasets using Pandas’ merging and concatenation features. They will practice joining DataFrames based on indexes and working across multiple axes.

    Topics to Cover:

    • Merging DataFrames
    • Combining datasets using indexes
    • Concatenation along different axes

  • Chapters 8–10: GroupBy Mechanics, Operations, and Transformations

    Overview:

    In these chapters, participants will master the GroupBy process in Pandas. They will learn how to split, apply, and combine data, perform group-wise operations, and apply advanced techniques such as binning and quartile analysis.

    Topics to Cover:

    • Understanding the GroupBy process (split-apply-combine)
    • Performing group-wise operations and transformations
    • Applying binning, quartiles, and bucket analysis

  • Chapter 11: Web Scraping & API

    Overview:

    In this chapter, participants will go beyond static datasets by learning how to collect data from the web. They will be introduced to web scraping with BeautifulSoup and Selenium, and learn how to connect to APIs for data access.

    Topics to Cover:

    • Introduction to web scraping concepts
    • Using BeautifulSoup and Selenium for scraping
    • Accessing and working with APIs

  • Chapter 12: Python Mini Projects

    Overview:

    In this chapter, participants will apply their data wrangling skills to real-life datasets. They will work on mini projects to solve business problems across different domains, such as finance and operations.

    Topics to Cover:

    • Applying skills to real-world datasets
    • Solving practical business problems (e.g., finance, operations)
    • Building end-to-end data wrangling workflows

Tools

Python
Anaconda
Jupyter
Ready to start learning?

Get access to top-rated courses, real projects, and job-ready skills.

Have questions?

We’re here to help. Talk to our advisors. 

STUDENT REVIEWS

What our graduates are saying

Recommended if you're interested in Data Wrangling with Python
Standard Course

AI Automation

Standard Course

Introduction to GitHub Actions

Standard Course

GCP Fundamentals

Standard Course

Introduction to Large Language Models

Learning Track

DevOps Engineering Track

Learning Track

MLOps Engineering Track

Learning Track

Cloud Engineering Track

Learning Track

Artificial Intelligence (AI) Engineering Track

Common Questions

Find answers to your questions about the Learning Track
  • Standard Courses: Focused, short courses that build foundational or intermediate skills through hands-on exercises, enabling you to apply what you learn immediately.
  • Track Courses: Structured learning paths that guide you from beginner to advanced levels. They include practical projects that integrate multiple tools and workflows, aligned with industry best practices, helping you gain the skills and confidence to tackle real-world challenges.

No. Track Courses are only accessible through the Professional or Unlimited+ subscription plans.

  • Standard Plan gives you access to all Standard Courses.
  • Professional Plan gives you access to both Standard and Track Courses within your chosen domain.
  • Unlimited+ Plan provides full access to all courses — both Standard and Track — across all domains.

 

Yes, all courses are designed to be self-paced. Learn when it fits your schedule.

Each course includes prerequisites if needed. Many Standard Courses are beginner-friendly.

Still have questions?

If you have other queries or specific concerns, don’t hesitate to let us know. Your feedback is important to us, and we aim to provide the best support possible.

Your Learning Journey Awaits 🚀

Grow your skills, build projects you’ll be proud of, and unlock new opportunities — all at your pace.

Download Data Wrangling with Python Course Package