Develop the ONS Monthly script

[Lextuga007]

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]

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.