Phase 6: Overview Tab Notebooks (3 notebooks) #72

Closed
opened 2026-01-17 16:55:38 +00:00 by lmiranda · 1 comment
Owner

Overview

Create Jupyter notebooks documenting the Overview tab visualizations.

Notebooks to Create

Notebook Visualization Figure Factory
notebooks/overview/livability_choropleth.ipynb Livability score map choropleth.py
notebooks/overview/top_bottom_10_bar.ipynb Top/Bottom 10 neighbourhoods summary_cards.py or new
notebooks/overview/income_crime_scatter.ipynb Income vs Crime scatter New figure factory

Acceptance Criteria

  • Each notebook follows the standard template (Data Reference + Visualization)
  • SQL queries documented with sample output
  • Transformation steps explained
  • Figure factory imports work and render correctly
  • Notebooks execute without errors

Technical Notes

Overview tab metrics from mart_neighbourhood_overview:

  • Composite livability score
  • Median income
  • Crime rate correlation

Labels: Type/Feature, Priority/Medium, Complexity/Medium, Efforts/S, Component/Docs, Tech/Python

## Overview Create Jupyter notebooks documenting the Overview tab visualizations. ## Notebooks to Create | Notebook | Visualization | Figure Factory | |----------|---------------|----------------| | `notebooks/overview/livability_choropleth.ipynb` | Livability score map | `choropleth.py` | | `notebooks/overview/top_bottom_10_bar.ipynb` | Top/Bottom 10 neighbourhoods | `summary_cards.py` or new | | `notebooks/overview/income_crime_scatter.ipynb` | Income vs Crime scatter | New figure factory | ## Acceptance Criteria - [ ] Each notebook follows the standard template (Data Reference + Visualization) - [ ] SQL queries documented with sample output - [ ] Transformation steps explained - [ ] Figure factory imports work and render correctly - [ ] Notebooks execute without errors ## Technical Notes Overview tab metrics from `mart_neighbourhood_overview`: - Composite livability score - Median income - Crime rate correlation **Labels:** Type/Feature, Priority/Medium, Complexity/Medium, Efforts/S, Component/Docs, Tech/Python
Author
Owner

Completed 3 notebooks for Overview tab:

  1. livability_choropleth.ipynb - Choropleth map with livability scores
  2. top_bottom_10_bar.ipynb - Ranking bar chart of top/bottom neighbourhoods
  3. income_safety_scatter.ipynb - Scatter plot of income vs safety correlation

All notebooks follow the standard template with:

  • Data Reference section (SQL query, transformation steps, sample output)
  • Data Visualization section (figure factory usage)
Completed 3 notebooks for Overview tab: 1. `livability_choropleth.ipynb` - Choropleth map with livability scores 2. `top_bottom_10_bar.ipynb` - Ranking bar chart of top/bottom neighbourhoods 3. `income_safety_scatter.ipynb` - Scatter plot of income vs safety correlation All notebooks follow the standard template with: - Data Reference section (SQL query, transformation steps, sample output) - Data Visualization section (figure factory usage)
Sign in to join this conversation.