search

GSS-Cogs / family-homelessness

0 stars 0 forks source link

sg-housing-options-prevent1-statistics-in-scotland #10

Open LPerryman opened 4 years ago

LPerryman commented 4 years ago

Dataset Transformation/Pipeline creation

canwaf commented 3 years ago

Test is a test for @Tracey-B

canwaf commented 3 years ago

This dataset has 5 new code lists. Geography and period have been transformed appropriately. I hope it is easier to finish the code lists than it was to sort through the spreadsheet. Codelist outputs attached. Archive.zip

canwaf commented 3 years ago
OluEA commented 3 years ago

BA Checks complete. This transformation looks reasonable bar a few observations. Observations:

  1. Unable to filter by Period, Area & Measure Type
  2. 'Rate of approaches per 1,000 households' appear to have too many digits where value is present. Not sure if this is intended format
  3. Publication does reflect the 'Date published' (15/12/2020). It appears there's a mismatch between this date and the June 26 2019 (date issued) that's reflected on the publication
  4. Should we be able to sort the Percentages column (small to large and vice versa)?
RedWalters commented 3 years ago

Filter issues are known and are being addressed. Rate of Approaches data has been rounded to match the source data. Data published has been updated.