Pandas
Clean, transform, analyze, and reshape real-world datasets.
Master DataFrames, Series, data ingestion, handling missing values, filtering, groupby aggregations, and merging.
45 days
Beginner to Intermediate
Live online · One-to-one available · Group batches when scheduled
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.
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.
- Create a DataFrame containing product, quantity and price.
- Add a total column equal to quantity multiplied by price.
- Group by product and sum each product's total.
Check your result: Your grouped output shows one revenue total per product.
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.
- Pandas Sales Analysis & Reproducible Report
Beginner · Data Analysis
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
Chapters, Core Topics & Guided Tasks
Every chapter closes with a guided implementation task. The complete course ends with one portfolio-ready capstone project.
Curriculum Validation Basis
Core chapters are cross-checked against current official technology documentation and authoritative standards or academic references.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
Who is this course for?
Data analysts, researchers, students, and Python developers entering data careers.
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
* Free Demo is a 1-on-1 trial session, not the complete course.
Related Technical Courses
NumPy
Vectorized arrays, linear algebra & multidimensional math
Master N-dimensional arrays, vectorized computations, broadcasting, slicing, indexing, and linear algebra operations.
- numpy course
- learn numpy python
- numerical computing python
Matplotlib & Data Visualization
Statistical plots, custom figures & publication charts
Learn line charts, bar plots, histograms, scatter plots, subplots, Seaborn styling, and visual storytelling.
- matplotlib course
- data visualization python
- learn seaborn
Statistics for Data
Probability, hypothesis testing, distributions & variance
Learn descriptive statistics, probability distributions, hypothesis testing, confidence intervals, correlation, and regression.
- statistics for data science
- learn statistics online
- hypothesis testing
Ready to start your learning journey?
Apply today and our admissions team will review your application and guide you through the next steps.