01 — Data Acquisition & Exploratory Analysis
Ingests aggregated residential gas consumption by postal code, regional HDD data, and MPAC property tax roll summaries. Performs EDA on gas-temperature relationships across 150 synthetic postal codes.
natural-gas postal-code mpac exploratory-analysis
Pythonpandasnumpymatplotlibseaborn
Key Findings
- ● 150 postal codes with 24 months of residential gas data assembled from utility and MPAC sources
- ● Clear linear relationship between monthly gas consumption and HDD visible at the postal code level
- ● Customer counts range from 10–40 per postal code, typical of Ontario suburban FSAs