← All courses

Beginner to intermediate

Pandas for Data Analysis

Learn to load, inspect, select, clean, transform, summarize, and combine real-world tabular data with pandas.

For Python learners who want to work with labeled, tabular data

What you will learn

  • Explain the roles of Series, DataFrame, and index labels.
  • Read and write common tabular files and inspect data shape, values, and types.
  • Select rows and columns with labels, positions, and Boolean conditions.
  • Handle missing data, duplicates, and column types deliberately.
  • Create derived columns and aggregate data with groupby.
  • Combine tables using concatenation and key-based merges.
  • Complete a small analysis from raw records to a checked summary.

Where to use pandas

  • Explore and prepare spreadsheet-like or database-style data in Python.
  • Clean missing, duplicated, and incorrectly typed tabular values.
  • Summarize records by category and combine related datasets.

What this course does not cover

  • Pandas is not designed to replace a relational database for storing and querying datasets too large for memory.
  • This course focuses on tabular analysis, not a complete statistics, visualization, or machine-learning curriculum.

How to use this course

This course assumes basic Python knowledge, including lists, dictionaries, functions, and importing packages. Install pandas with python -m pip install pandas, then run examples in a Python script, REPL, or notebook. The examples use the conventional import pandas as pd.

Work through the chapters in order. Pandas keeps row and column labels alongside values, so understanding indexes and alignment helps prevent subtle selection and arithmetic errors. Examples focus on small in-memory datasets; for very large datasets, choose storage and processing tools appropriate to their size.

A tabular analysis workflow from loading and inspection through cleaning, transformation, validation, and communication

This visual roadmap reflects the operations described in the official pandas user guide.

Course chapters

  1. 01Series, DataFrames, and labelsMeet pandas’ core data structures and learn why labels and indexes matter.
  2. 02Load, inspect, and save dataRead tabular data and perform initial checks before analyzing it.
  3. 03Select, filter, and sortSelect columns and rows using labels, positions, and Boolean conditions.
  4. 04Clean missing values and typesDetect missing observations, handle duplicates, and choose a suitable column type.
  5. 05Transform and align dataCreate derived columns and understand how pandas aligns labels during calculations.
  6. 06Group and aggregateUse groupby to summarize records by one or more categories.
  7. 07Combine and reshape tablesConcatenate tables, merge related records by key, and reshape summarized data.
  8. 08Mini-project: analyze a small sales datasetPut file loading, data checks, filtering, grouping, and interpretation together in a compact analysis.
  9. 09pandas function indexSearch common pandas constructors, methods, and operations by name or task.

Documentation and further reading