Skip to main content
Data & AI
Beginner to Intermediate
45 days

Pandas

Clean, transform, analyze, and reshape real-world datasets.

Master DataFrames, Series, data ingestion, handling missing values, filtering, groupby aggregations, and merging.

Pandas illustrated course poster
Pacing & Duration

45 days

Experience Level

Beginner to Intermediate

Delivery Mode

Live online · One-to-one available · Group batches when scheduled

Learning Format

1-on-1 & small cohorts

Course overview

Pandas is the premier data manipulation library for data science and analytics in Python. In this course, you will learn to load data from CSVs and databases, clean dirty records, handle missing values, transform columns, group and aggregate data, and pivot complex tables.

Free, self-guided practice

Try a Pandas starter exercise

A practical first task you can try independently, without registration or payment. These instructions are for self-study; they are not a free live class or a downloadable project.

Your task

Summarize a tiny sales table with Pandas.

  1. Create a DataFrame containing product, quantity and price.
  2. Add a total column equal to quantity multiplied by price.
  3. Group by product and sum each product's total.

Check your result: Your grouped output shows one revenue total per product.

Ungated self-study

Free projects to practice this course

Open a hands-on starter kit with runnable example code, project milestones and a downloadable checklist. No signup or tuition is required for the guide.

Browse all free projects

What you'll achieve

Core competencies developed through practical implementation and project work.

  • Work fluently with Pandas Series and DataFrames
  • Ingest, clean, inspect, and export tabular datasets
  • Handle missing values, duplicate records, and data type conversions
  • Perform sophisticated grouping, aggregations, joins, and pivots
30–60 Day Structured Course

Chapters, Core Topics & Guided Tasks

Every chapter closes with a guided implementation task. The complete course ends with one portfolio-ready capstone project.

45 days 3–4 classes/week

Curriculum Validation Basis

Core chapters are cross-checked against current official technology documentation and authoritative standards or academic references.

  1. Chapter 01

    Series, DataFrames & Data Import

    Core topics

    • Core structures and indexes
    • CSV, Excel, JSON, and SQL input
    • Inspection and data types

    Guided chapter task

    Load and profile a supplied multi-column dataset.

  2. Chapter 02

    Cleaning & Validation

    Core topics

    • Missing values
    • Duplicates
    • Type conversion, dates, and text cleanup

    Guided chapter task

    Create a repeatable cleaning checklist with before/after evidence.

  3. Chapter 03

    Selection, Transformation & Grouping

    Core topics

    • loc and iloc
    • Vectorized transformations
    • groupby and aggregation

    Guided chapter task

    Answer a set of business questions from clean tabular data.

  4. Chapter 04

    Merging & Reshaping

    Core topics

    • merge, join, and concat
    • Pivot tables
    • Melt and tidy-data patterns

    Guided chapter task

    Combine related tables into an analysis-ready dataset.

  5. Chapter 05

    Time Series & Exploratory Analysis

    Core topics

    • Datetime indexes
    • Resampling and rolling summaries
    • Outliers and descriptive EDA

    Guided chapter task

    Analyze trends and anomalies across a dated dataset.

  6. Chapter 06

    Reporting & Export

    Core topics

    • Charts and summaries
    • Styled tables awareness
    • Exporting clean data and findings

    Guided chapter task

    Deliver a clean dataset plus a concise reproducible analysis report.

Complete Course Capstone

Portfolio Project

Complete a customer or sales EDA project from raw files to validated findings and exportable reports.

Prerequisites & Prior Knowledge

Recommended background before starting this course. Mentors adapt pacing to your current level.

Python fundamentals and basic NumPy concepts.
Target Audience

Who is this course for?

Data analysts, researchers, students, and Python developers entering data careers.

Delivery & Mentoring

Hands-on Learning Format

  • Live interactive screen-sharing
  • 1-on-1 personalized instruction
  • Practical, portfolio-ready code

Contact admissions for current fee and available learning formats

Enrol in Pandas

Start with a 1-on-1 trial session to discuss your technical goals with an instructor.

  • Duration: 45 days
  • Level: Beginner to Intermediate
  • Delivery: Live online · One-to-one available · Group batches when scheduled
  • Format: 1-on-1 & small cohorts
Apply for this course Request Free Demo Trial

* Free Demo is a 1-on-1 trial session, not the complete course.

Ready to start your learning journey?

Apply today and our admissions team will review your application and guide you through the next steps.