Home

OFM April 1 data

OFM processing scripts require the following python libraries: pandas, panda.api.types, numpy, urllib, requests, pyodbc, sqlalchemy, os, functools.

Run the following scripts in this order:

1. download_ofm_apr.py: This script will download April 1 excel files for intercensal & postcensal population and postcensal housing units into housing-metrics/data.
2. elmer_staging.py: This script will executed respective tidying scripts and push to Elmer's stg schema. The tables will be named: ofm_apr_intercensal, ofm_apr_postcensal, and ofm_apr_postcensal_housing.