This is a 100% hands-on course that teaches you real-world data manipulation through direct side-by-side comparison of Pandas and Polars — the two most important Python DataFrame libraries today. Every single exercise gives you the same task solved in BOTH libraries, so you can immediately see differences in API design, performance, and idiomatic style. No long lectures. No slides. Just clear assignments, clean solutions, and reference material you can use on the job.
The course is structured in 5 progressive blocks:
- 1. Fundamentals: Loading CSVs, selecting columns, filtering rows, data types, string operations, date/time handling, null management, and export to multiple formats.
- 2. Aggregations & Joins: GroupBy operations, pivot/melt, all types of joins, window functions, rolling aggregations, resampling, and ranking.
- 3. Advanced Patterns: Lazy evaluation, method chaining, user-defined functions, nested/struct data, multi-format interop, and performance optimization.
- 4. Extras: Categorical types & memory optimization, large file streaming, data visualization with matplotlib and seaborn, multi-file ingestion (glob patterns, partitioned datasets), and data validation pipelines
5. Real world Projects:
- Data Cleaning & Normalization
- Sales Dashboard Report
- ETL Pipeline (multi-source)
- Customer Churn & Cohort Analysis
- Financial Risk & Portfolio Optimization
- ML Feature Engineering Pipeline
- Real-time Streaming Dashboard (2M+ rows)






