Joining and Merging DataFrames
Working with Strings and Dates
Going Further: Optional Deep Dives
The slide deck used in the Week 4 in-class kickoff session. The deck covers: welcome back + recap, the live quiz, chapter-by-chapter tour (Ch1-Ch10), two live exercises from the practice chapter, the agenda card, the assignment scaffold tour, and the closing hand-written reflection.
<aside> ๐ก Use this as a recap. If you missed class or want to re-walk the agenda, the deck mirrors the structure of the lesson: same section numbers, same order. Especially useful for the assignment-launch walk-through (ยง9) when you start the assignment at home.
</aside>
week_4__presentation.pdf
info() vs describe() for schema inspection), Ch2 (boolean masks, loc vs iloc), Ch3 (groupby named aggregations, count vs size), Ch4 (the join-explosion pattern, duplicate key deduplication), Ch5 (.str and .dt accessors, pd.to_datetime(errors="coerce")). Each chapter slide carries a ๐ฆ Run along: pointer to its assets/companion_chN_*.py script.pivot_table vs melt, rolling, apply vs built-ins), Ch7 (CSV vs Parquet, Parquet round-trip), Ch8 (visualization as validation, saved chart artifacts), Ch9 (three signals to leave Pandas: RAM, profiled runtime, parallel cores), Ch10 (notebooks for exploration, scripts for production).SettingWithCopyWarning and when .copy() is needed" (Gotchas) + "count vs size in groupby" (Ch3).messy_sales.csv walk-through with deliberate problems.The slides are deliberately student-facing only. The teacher's per-section script (pacing, quiz answer cribs with common-wrong-pick analysis, exercise reference solutions, deep-dive default topics, closer rubric) lives in the GitHub-only week_4__14_lesson_plan.md (visible on GitHub only; not synced to Notion, so no link from this page).
The two live exercises the deck showcases come from the Learning-Resources repo. One Codespace covers all five exercises:
| Section | Exercise | Codespace folder |
|---|---|---|
| ยง3 Live Exercise A (recommended) | Ex 3: Groupby and Aggregation | data-track/week-4/exercise_3/ |
| ยง3 Live Exercise A (alternative) | Ex 2: Filtering and Sorting | data-track/week-4/exercise_2/ |
| ยง7 Live Exercise B (recommended) | Ex 5: Reshape and Export | data-track/week-4/exercise_5/ |
| ยง7 Live Exercise B (alternative) | Ex 4: Joining Two Tables | data-track/week-4/exercise_4/ |
The teacher chooses which to run live based on quiz wrong-pick patterns. Solutions live in each exercise_N/solutions/ folder, with # WHY ...: commentary under every non-obvious choice: read the reasoning, do not copy the code verbatim.
The HackYourFuture curriculum is licensed underย CC BY-NC-SA 4.0 *https://hackyourfuture.net/*

Built with โค๏ธ by the HackYourFuture community ยท Thank you, contributors
Found a mistake or have a suggestion? Let us know in the feedback form.