Phase 6: Housing Tab Notebooks (3 notebooks) #73

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

Overview

Create Jupyter notebooks documenting the Housing tab visualizations.

Notebooks to Create

Notebook Visualization Figure Factory
notebooks/housing/affordability_choropleth.ipynb Affordability index map choropleth.py
notebooks/housing/rent_trend_line.ipynb 5-year rent trend line chart time_series.py
notebooks/housing/dwelling_types_bar.ipynb Dwelling types breakdown New or existing

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

Housing tab metrics from mart_neighbourhood_housing:

  • Affordability index
  • Rent-to-income ratio
  • CMHC rental data (allocated via bridge table)

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

## Overview Create Jupyter notebooks documenting the Housing tab visualizations. ## Notebooks to Create | Notebook | Visualization | Figure Factory | |----------|---------------|----------------| | `notebooks/housing/affordability_choropleth.ipynb` | Affordability index map | `choropleth.py` | | `notebooks/housing/rent_trend_line.ipynb` | 5-year rent trend line chart | `time_series.py` | | `notebooks/housing/dwelling_types_bar.ipynb` | Dwelling types breakdown | New or existing | ## 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 Housing tab metrics from `mart_neighbourhood_housing`: - Affordability index - Rent-to-income ratio - CMHC rental data (allocated via bridge table) **Labels:** Type/Feature, Priority/Medium, Complexity/Medium, Efforts/S, Component/Docs, Tech/Python
Author
Owner

Completed 3 notebooks for Housing tab:

  1. affordability_choropleth.ipynb - Choropleth map with affordability index
  2. rent_trend_line.ipynb - 5-year rent trend by bedroom type
  3. tenure_breakdown_bar.ipynb - Owner vs renter tenure mix by neighbourhood
Completed 3 notebooks for Housing tab: 1. `affordability_choropleth.ipynb` - Choropleth map with affordability index 2. `rent_trend_line.ipynb` - 5-year rent trend by bedroom type 3. `tenure_breakdown_bar.ipynb` - Owner vs renter tenure mix by neighbourhood
Sign in to join this conversation.