search

CDU-data-science-team / ons-data-tidy

Data set preparation for ONS datasets.
MIT License
0 stars 1 forks source link

Develop the ONS Monthly script #1

Open Lextuga007 opened 4 years ago

Lextuga007 commented 4 years ago

This R script needs more data manipulation code on the ONS monthly mortality data from wide form to long, with particular coding around District codes and names needed. Some code has already been written for downloading the spreadsheets and extracting the individual tabs to csv files and is based on the structure of the code used https://github.com/CDU-data-science-team/ONSDataCleansing/blob/master/R/mortality_ONS_2020.R.

The ONS weekly mortality data is used in many applications and analysis around Covid-19 deaths and appears in the R package NHSRdatasets that is on CRAN https://github.com/nhs-r-community/NHSRdatasets.

Help can be provided and the NHS-R Community will be holding a Hacktoberfest day on the 20th October. See the Hacktoberfest site for more details (or comment here).

Lextuga007 commented 4 years ago

It may be that https://github.com/HFAnalyticsLab/monstR package can help with some of the data manipulation if this is available on the API.