spb/qwhpi Public
QHPI — Quebec Housing Price Index: quality-adjusted, hierarchically pooled housing price indexes.
Python 63.9%
TypeScript 25.4%
CSS 5.5%
TeX 3.5%
SQL 0.8%
Makefile 0.5%
Dockerfile 0.5%
1<!--2=============================================================================3QWHPI — Quebec Weekly Housing Price Index4Author : Simon-Pierre Boucher5Contact : contact@spboucher.ai6File : outputs/reports/geography_report.md7Purpose : Step 2 geography join + validation report (from 02_geography.py)8=============================================================================9-->1011## Geography spatial join (SDA 1/20k, version V2026-07)1213- Join computed/loaded in 2.1s for 745,119 transactions14- join_method=within: 745,119 (100.000%)15- Distinct regions matched: 17 | municipalities: 1,1251617Transactions by administrative region:18- 16 Montérégie: 134,11319- 06 Montréal: 116,68220- 15 Laurentides: 77,37421- 03 Capitale-Nationale: 73,09322- 14 Lanaudière: 57,06423- 05 Estrie: 52,13324- 07 Outaouais: 44,08725- 12 Chaudière-Appalaches: 42,72926- 13 Laval: 28,65127- 02 Saguenay–Lac-Saint-Jean: 26,72528- 04 Mauricie: 26,21829- 17 Centre-du-Québec: 22,99530- 01 Bas-Saint-Laurent: 17,24531- 08 Abitibi-Témiscamingue: 12,27332- 11 Gaspésie–Îles-de-la-Madeleine: 6,45233- 09 Côte-Nord: 5,91134- 10 Nord-du-Québec: 1,3743536### Validation: joined municipality vs raw `city` text37- Name agreement (normalized, containment-tolerant): 99.92%38- Mismatching pairs saved: outputs/tables/geo_city_mismatch_top300.csv (7 distinct pairs, 618 transactions)3940Top 15 mismatch pairs (city text -> joined municipality):41- 'Saint-Bruno' -> 'Hébertville' (Saguenay–Lac-Saint-Jean): 29242- 'Courcelles-Saint-Évariste' -> 'Courcelles–Saint-Évariste' (Chaudière-Appalaches): 14043- 'Saint-Félix-de-Dalquier' -> 'Amos' (Abitibi-Témiscamingue): 9544- 'Saint-Onésime-d'Ixworth' -> 'La Pocatière' (Bas-Saint-Laurent): 6145- 'Passes-Dangereuses' -> 'Sainte-Élisabeth-de-Proulx' (Saguenay–Lac-Saint-Jean): 1646- 'Saint-Guy' -> 'Lac-des-Aigles' (Bas-Saint-Laurent): 1347- 'TNO aquatique de la MRC d'Argenteuil' -> 'Grenville-sur-la-Rouge' (Laurentides): 148