Pandas Workshop: A Complete Guide to Data Processing from Beginner to Expert

This open-source project is maintained by mr-pylin and hosted on GitHub. It is a systematic Pandas learning guide from beginner to expert, presented in Jupyter Notebook format. It covers core skills from basic data structures to advanced data cleaning, aggregation, and merging through seven progressive modules, suitable for data science and machine learning practitioners to learn systematically. Each module includes abundant code examples and practical exercises.

Original Author and Source

• Original Author/Maintainer: mr-pylin
• Hosting Platform: GitHub
• Original Link: https://github.com/mr-pylin/pandas-workshop
• Release Date: June 1, 2026

Project Overview

Pandas Workshop is an open-source data processing learning project designed to provide a structured learning path for data science and ML practitioners. Unlike scattered tutorials, it is structured into seven modules in Jupyter Notebook format, covering practical work scenario needs from basic to advanced levels, with code examples and practical exercises.

The entire tutorial is divided into seven progressive modules:

1. Pandas Introduction: Overview and positioning, relationship with NumPy, installation and configuration (recommended uv tool);
2. Data Structure Analysis: Core operations and memory management of Series (1D labeled array) and DataFrame (2D table);
3. Data Input/Output: Reading and writing formats like CSV/Excel/JSON/SQL/Parquet, chunked reading and memory optimization;
4. Indexing and Selection: Differences between loc/iloc, multi-level indexing, boolean indexing, and performance optimization;
5. Data Cleaning and Transformation: Missing value handling, type conversion, duplicate data processing, string operations, data pivoting and reshaping;
6. Aggregation and Grouping: groupby mechanism, custom aggregation, window functions;
7. Data Merging and Reshaping: join/merge/concatenate, comparison of join types, pivot tables and long-wide format conversion.

Tech Stack Requirements

• Python Version: 3.10+ (3.13.9 used for development)
• Core Dependencies: pandas 2.3.3, numpy 2.3.4, matplotlib 3.10.7, plotly 6.3.1, etc.
• Recommended Environment: VS Code with Jupyter extension; simply open .ipynb files to learn.

Prerequisite Knowledge

• Basic Python Programming: Proficiency in syntax, data types, functions, etc. (the author provides a配套 Python Workshop);
• Basic NumPy: Understanding array operations (prerequisite resource: NumPy Workshop).

Related Resource Ecosystem

• Data Visualization: Workshops for Matplotlib, Seaborn, Plotly;
• Machine Learning: Complete learning path for PyTorch;
• Image Processing: Resources for OpenCV, scikit-image, etc.

Learning Suggestions:

1. Learn by Doing: Reproduce code examples and modify parameters to observe changes;
2. Real Data: Apply learned techniques to your own datasets;
3. Take Notes: Record common processing patterns and solutions;
4. Engage with the Community: Seek help and share insights on GitHub Issues and Stack Overflow.

Project Maintenance

• Active Maintenance: Dependencies are regularly updated to stable versions;
• License: Apache 2.0, allowing free use, modification, and distribution;
• Feedback Channels: GitHub Issues/PRs; the author provides a Linktree for contact.

Conclusion

Pandas Workshop provides systematic and practical learning resources to help users grow from zero to data processing professionals. In the data-driven era, mastering Pandas is a fundamental skill for data science practitioners, suitable for both beginners and those looking to advance their skills.