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

## TL;DR

RxTrends is an R-based tool that visualizes medication prescription trends in Ireland using public data, helping stakeholders analyze drug use and policy.

## Contribution

A novel Shiny application for interactive and user-friendly analysis of prescription data trends in Ireland.

## Key findings

- The RxTrends application enables visualization of prescribing trends for the 100 most prescribed medications and therapeutic groups.
- The application includes features like time-based filtering and comparison of medication proportions within therapeutic groups.
- Use cases demonstrate its utility in analyzing drug policy, generic availability, and seasonal drug use patterns.

## Abstract

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 user-friendly 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.

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.

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.

The application provides a user-friendly way 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.