RxTrends: An R-based Shiny Application for Visualising Open Data on Prescribed Medications in Ireland.

BACKGROUND

The Health Service Executive (HSE) in Ireland releases monthly reports on prescription dispensing claims and payments relating to community drug schemes. This paper describes the implementation of an R-based Shiny application that facilitates interactive visualisation and analysis of trends in medication prescribing and improves the data's practical value, and presents use cases focused on drug utilisation and medication policy questions.

METHODS

Using Primary Care Reimbursement Service (PCRS) data provided by the HSE relating to the means-tested General Medical Services (GMS) scheme covering approximately one-third of the population, an R-based Shiny application was developed. This application uses monthly prescribing and cost data from 2016 up to the most recent data available (currently October 2024) relating to the 100 most commonly prescribed medications (by frequency and cost) and all therapeutic groups. The application leverages a range of R packages to enable users to select medications, therapeutic groups, and physiological systems to explore and compare prescribing and cost trends over time.

RESULTS

The RxTrends Shiny application effectively integrates PCRS data, providing multiple functionalities that allow for visualisation of dispensing trends of multiple medications, therapeutic groups and physiological systems. Graphs are available across multiple prescribing frequency and cost metrics and can be restricted to a selected time period. The 'compare' function visualises the proportion of prescribing/cost a selected medication or therapeutic group accounts for within a therapeutic group or physiological system. Use cases relating to Ireland's Preferred Drug Initiative, availability of generic products and reference pricing, and seasonality of drug utilisation are presented.

CONCLUSION

The application provides an interactive interface for stakeholders to visualise and monitor prescribing patterns using data from monthly PCRS reports. The application increases access to and usability of PCRS data for various audiences for whom it may be of interest, including researchers, healthcare professionals, policymakers and the general public.