26 lines (26 loc) · 1.35 KB

Phase 1: Coding Fundamentals (Weeks 1-8)

Week 1: Introduction to Python, variables, and data types
Week 2: Operators and expressions (basic math, boolean logic)
Week 3: Control flow (if-else statements)
Week 4: Loops (for, while)
Week 5: Functions (writing reusable code)
Week 6: Lists, tuples, and dictionaries (essential data structures)
Week 7: File handling (reading/writing CSV, JSON)
Week 8: Introduction to error handling (try-except)

Phase 2: Data Wrangling & Pandas (Weeks 9-16)

Week 9: Introduction to Pandas (DataFrames, Series)
Week 10: Loading and exploring datasets (CSV, Excel)
Week 11: Data cleaning (handling missing values, duplicates)
Week 12: Filtering and sorting data
Week 13: Data aggregation and group operations
Week 14: Data transformation (applying functions, reshaping data)
Week 15: Merging and joining datasets
Week 16: Basic data visualization with Pandas

Phase 3: SQL for Data Science (Weeks 17-23)

Week 17: Introduction to SQL (databases, tables, SELECT queries)
Week 18: Filtering and sorting data (WHERE, ORDER BY)
Week 19: Aggregation (COUNT, SUM, AVG, GROUP BY)
Week 20: Joins (INNER JOIN, LEFT JOIN)
Week 21: Subqueries and common table expressions (CTEs)
Week 22: Using SQL with Pandas (loading database tables into Python)
Week 23: Writing complex queries for real-world data wrangling