This repository is created to show the data cleansing steps using Pandas.
The tutorial file is ONenergy.ipynb You can either download it and run ipython notebook ONenergy.ipynb interactively in your terminal, or read it on GitHub.
The data used is from Energy use and green house gases emitted by the Broader Public Sector data.
##Description: ###Energy use and greenhouse gas emissions for the Broader Public Sector Date published: February 18, 2014 Date modified: December 19, 2014 Publisher: Energy Tags: Environment and energy File types: XLSX Time Period: 2011-01-01 to 2012-12-31 Update frequency: Yearly Geographical coverage: Ontario
Shows the amount of energy used and greenhouse gases (GHG) emitted for the Broader Public Sector, i.e., municipalities, municipal service boards, school boards, universities, colleges and hospitals.
Public agencies play an important role in helping Ontario meet its conservation targets and reduce Greenhouse Gas emissions. Beginning July 1, 2013 the Green Energy Act, 2009 requires Ontario’s Broader Public Sector (BPS) to report their annual energy use and Greenhouse Gas emissions, every year, to the Ministry of Energy.
The data contained in this file was provided by broader public sector organizations in accordance with this annual reporting requirement. A number of organizations also reported on facilities not required by the regulation.
This file contains 4 tabs:
tab 1 contains 2011 raw energy consumption and GHG emission data tab 2 contains 2011 data that has been normalized to account for weather conditions tab 3 contains 2012 raw energy consumption and GHG emission data tab 4 contains 2012 data that has been normalized to account for weather conditions. Normalized data allows BPS organizations and the public to accurately compare the energy consumption of similar BPS operations in one part of the province to those in another part of the province.
Missing or incorrect data is the sole responsibility of the BPS organization. The ministry has attempted to remove duplicate data from this data set to improve data integrity.
BPS organizations are required to make their information publicly available on their respective websites and in hard copy upon request.