RRR: Re-purposing Routine information with R: Local Health and slope index of inequality (SII)
PHE ePoster Library. Bates I. Sep 12, 2017; 186488; 155
Mr. Ian Bates
Mr. Ian Bates
Login now to access Regular content available to all registered users.

You may also access this content "anytime, anywhere" with the Free MULTILEARNING App for iOS and Android
Abstract
Rate & Comment (0)
Abstract IntroductionOur main aim was to ease production of slope indices of inequality for each upper tier authority in England based on information within the PHE Local Health tool.A secondary aim was to use the software package R to automate the process.Usual methods for SII calculation involving e.g. Excel are manually intensive for many datasets and potentially prohibitively so for the Local Health dataset which comprises over 70 indicator datasets spanning over 150 upper tier local authorities.MethodWe developed an algorithm to extract, transform and analyse the indicator information from Local Health using R.The problem was broken into a number of steps that included extracting the data from the Local Health website, transforming it into a dataset to more suitable for further processing, developing a function to calculate slope index of inequality and finally performing the calculations.ResultsWe were successful in calculating slope index of inequality values by upper tier local authority in England using Local Health data and R.Conclusion and DiscussionOn balance the use of R for this problem has been beneficial.Despite a steep learning curve development of the script-based automated process revealed a number of advantages over a manual process including:audit of process (e.g. "how did I do that?")ability to replicate reliably (e.g. updated datasets)robust transformation and processing of data (e.g. avoiding manual errors)efficiency through automation for repetitive tasks (e.g. minimising manual effort)Interpretation of these results is the subject of a further piece of work.
    This eLearning portal is powered by:
    This eLearning portal is powered by MULTIEPORTAL
Anonymous User Privacy Preferences

Strictly Necessary Cookies (Always Active)

MULTILEARNING platforms and tools hereinafter referred as “MLG SOFTWARE” are provided to you as pure educational platforms/services requiring cookies to operate. In the case of the MLG SOFTWARE, cookies are essential for the Platform to function properly for the provision of education. If these cookies are disabled, a large subset of the functionality provided by the Platform will either be unavailable or cease to work as expected. The MLG SOFTWARE do not capture non-essential activities such as menu items and listings you click on or pages viewed.


Performance Cookies

Performance cookies are used to analyse how visitors use a website in order to provide a better user experience.


Save Settings