search

GSS-Cogs / family-climate-change

1 stars 1 forks source link

ONS-Atmospheric-emissions-greenhouse-gas-emissions-intensity-by-industry #80

Open Shannon95 opened 3 years ago

Shannon95 commented 3 years ago
Shannon95 commented 3 years ago

Initial transformation completed and output files. Needs code list creation and mapping to proceed.

Source data consists of 3 tabs with data to transform - will need confirmation on what to do with the final tab as it lacks info / might need to be extracted by itself.

Note the output contains a dimension Section which is an amalgamation of the columns in the screenshot below. image.png which will need to use a unique codelist as some of the URI's have had to be bespoke.

So for the sic codes: http://business.data.gov.uk/companies/def/sic-2007/A And then for the bespoke entries: http://gss-data.org.uk/data/gss_data/climate-change/ons-energy-use-by-industry-reallocated-to-final-consumer-and-energy-intensity#concept/sic-2007/total

I believe this will be the same for #67, #70, #75, #78

This has also been done with #23

https://github.com/GSS-Cogs/family-climate-change/tree/master/datasets/BEIS-Supplementary-tables-2019-UK-greenhouse-gas-emissions-by-Standard-Industrial-Classification

Shannon95 commented 3 years ago

Published to staging here

and avilable as a draft on beta.