Published on in Vol 21, No 6 (2019): June

Preprints (earlier versions) of this paper are available at, first published .
Rapid Analysis of Diagnostic and Antimicrobial Patterns in R (RadaR): Interactive Open-Source Software App for Infection Management and Antimicrobial Stewardship

Rapid Analysis of Diagnostic and Antimicrobial Patterns in R (RadaR): Interactive Open-Source Software App for Infection Management and Antimicrobial Stewardship

Rapid Analysis of Diagnostic and Antimicrobial Patterns in R (RadaR): Interactive Open-Source Software App for Infection Management and Antimicrobial Stewardship

Original Paper

1Department of Medical Microbiology and Infection Prevention, University Medical Center Groningen, University of Groningen, Groningen, Netherlands

2Certe Medical Diagnostics and Advice, Groningen, Netherlands

3APEMAC, Université de Lorraine, Nancy, France

4Infectious Diseases Department, CHRU-Nancy, Université de Lorraine, Nancy, France

Corresponding Author:

Christian Friedemann Luz, MSc, MD

Department of Medical Microbiology and Infection Prevention

University Medical Center Groningen

University of Groningen

Hanzeplein 1

Groningen, 9713 GZ


Phone: 31 50 361 3480

Fax:31 50 36 19105


Background: Analyzing process and outcome measures for all patients diagnosed with an infection in a hospital, including those suspected of having an infection, requires not only processing of large datasets but also accounting for numerous patient parameters and guidelines. Substantial technical expertise is required to conduct such rapid, reproducible, and adaptable analyses; however, such analyses can yield valuable insights for infection management and antimicrobial stewardship (AMS) teams.

Objective: The aim of this study was to present the design, development, and testing of RadaR (Rapid analysis of diagnostic and antimicrobial patterns in R), a software app for infection management, and to ascertain whether RadaR can facilitate user-friendly, intuitive, and interactive analyses of large datasets in the absence of prior in-depth software or programming knowledge.

Methods: RadaR was built in the open-source programming language R, using Shiny, an additional package to implement Web-app frameworks in R. It was developed in the context of a 1339-bed academic tertiary referral hospital to handle data of more than 180,000 admissions.

Results: RadaR enabled visualization of analytical graphs and statistical summaries in a rapid and interactive manner. It allowed users to filter patient groups by 17 different criteria and investigate antimicrobial use, microbiological diagnostic use and results including antimicrobial resistance, and outcome in length of stay. Furthermore, with RadaR, results can be stratified and grouped to compare defined patient groups on the basis of individual patient features.

Conclusions: AMS teams can use RadaR to identify areas within their institutions that might benefit from increased support and targeted interventions. It can be used for the assessment of diagnostic and therapeutic procedures and for visualizing and communicating analyses. RadaR demonstrated the feasibility of developing software tools for use in infection management and for AMS teams in an open-source approach, thus making it free to use and adaptable to different settings.

J Med Internet Res 2019;21(6):e12843




With antimicrobial resistance (AMR) on the rise, efforts are being made worldwide to focus on the preservation of antimicrobials as a precious nonrenewable resource. Infection management in the form of antimicrobial stewardship (AMS) programs has emerged as an effective solution to address this global health problem in hospitals. AMS programs are defined as “a coherent set of actions which promote using antimicrobials responsibly” [1]. Stewardship interventions and activities focus on individual patients (personalized medicine and consulting) as well as patient groups or clinical syndromes (guidelines, protocols, information technology infrastructure, and clinical decision support systems) while prioritizing improvement in quality of care and patient safety for any intervention. The appropriate use of antimicrobials based on accurate and timely diagnostics is integral for the successful management of infections. In doing so, the diagnostics contribute to efforts in minimizing AMR by optimizing the use of antimicrobials.

AMS setups in hospitals are often heterogeneous, but audit and feedback to assess the goals are essential parts of most programs, and they are included in international guidelines and reviews [2-7]. Important data for AMS programs include, for example, days of therapy (DOT), daily defined doses (DDD), admission dates, length of stay (LOS), and adherence to local or national diagnostic, therapeutic, or infection management guidelines [1]. Clinical outcomes, quality of care, or consumption of hospital resources can be measured, for example, using mortality data or surrogate parameters such as LOS. The collection of these data is facilitated by electronic health records (EHRs) and administrative local databases. Notably, administrative data have also been shown to be a reliable source for assessing clinical outcomes [8].

EHRs usually offer quick insights into useful infection management data on the individual patient level. However, easy access to analyze patient groups (eg, stratified by departments or wards, specific antimicrobials, or diagnostic procedures used) is difficult to implement in daily practice. It is even more challenging to rapidly analyze larger patient populations (eg, spread over multiple specialties) even though this information might be available. Nevertheless, this is vital for meaningful analysis, including possible confounders and pattern recognition across different populations. Moreover, when aggregated data are available, it is often not possible to trace individual patients, and analyses lack the ability to be further adjusted or stratified.

AMS teams are multidisciplinary, and they act beyond the borders of single specialties [9]. They are usually understaffed, with limited data analysis support [10,11]. Therefore, they need user-friendly and time-saving data analysis resources, without the need for profound technical expertise once the system is set up. Aggregating and linking data of antimicrobial use, guideline adherence, and clinical outcomes at the institutional level can build the basis for important insights for these teams. These could be used to identify areas within hospitals that might benefit most from supportive AMS interventions (eg, subspecialties with lower guideline adherence or unusual patterns of antimicrobial use). Moreover, feedback from these data could help physicians better understand their patient population as a whole; in addition, hospital administration could allocate resources in a more targeted fashion.

Furthermore, aggregated data and simultaneous analysis of multiple areas (eg, use of diagnostics and antimicrobials) present an extensive insight into large patient populations. This also enables the development of comprehensive and multidisciplinary approaches of infection management, combining diagnostic and therapeutic perspectives [1,9,12]. Unfortunately, these kinds of analyses still require substantial statistical knowledge and software skills, and it is time consuming when performed.

Technology, data science, and software app development can bring solutions to complex data handling problems such as those described above. Software app development for medical and epidemiological (research) questions has found many important answers during recent years. For example, software apps at hospital emergency departments (EDs) in the form of a dashboard have been shown to improve efficiency and quality of care for patients requiring emergency admission to hospital [13]. These software apps are used to communicate clearly defined clinical problems, such as mortality ratio, number of cardiac arrests, or readmission rate to the EDs. This has led to a decreased LOS and mortality at the EDs. Others used similar approaches to rapidly and interactively display geographical locations of tuberculosis cases without the need of technical expertise improving the understanding of transmission and detection [14]. Furthermore, data-driven fields such as genomics are front runners in developing new, innovative software apps to handle large datasets, in close collaboration with bioinformatics [15]

It is important to note that all of these abovementioned software apps have been created in an open-source approach. This means that the underlying source code can be easily shared, easily modified, and freely distributed through open repositories, such as GitHub [16], taking open-source software license obligations into account. This facilitates collaboration, quality control through code review, and easy adaptation to many different settings and information technology systems, and this supports the use of advanced data visualization for users with minimal experience in programming and little or no budget for professional database engineers [15].

In the field of medical microbiology, different approaches have been described to interactively work with microbiological diagnostics data and EHRs: electronic antibiograms, centralized resistance analysis, EHR data mining, and clinical decision support systems for AMS are great examples for innovation in the field [17-19]. However, a full open-source approach for software apps working with combined antimicrobials use and diagnostic data of individual patients on the hospital level in the field of infection management is still lacking.


We followed principles of open knowledge [20] to address the need for an interactive, easy-to-use software app that allows users to investigate antimicrobial use, microbiological diagnostic use, and patient outcomes at an institutional (hospital) level. We developed an open-source, Web-based software app—Rapid analysis of diagnostic and antimicrobial patterns in R (RadaR) that can be used for AMS and infection management. This free software app can be run on regular computers or implemented on local or Web-based servers to be accessed through standard Web browsers. The focus user group of this software app is health care professionals involved in AMS (eg, infectious disease specialists, clinical microbiologists, and pharmacists). Although some technical expertise (basic R knowledge) is needed for installation and implementation, the use of RadaR follows usual Web browser user experiences. RadaR enables rapid and reproducible data analysis without extensive previous analysis expertise in a graphically appealing way while being adaptable to different settings. RadaR’s analyses are based on datasets of individual patients. Therefore, aggregated results can also be stripped down, and additional patient features can be investigated. With this software app, we aim at supporting data-driven hospital insights and decision making for actors in the field of AMS in a free, transparent, and reproducible way.

For the development of software in an open-source environment, we used the open-source programming language R in conjunction with RStudio version 1.1.463 (RStudio, Inc) [21], an open-source integrated desktop environment for R [22]. Both R and RStudio are free of charge, and they need to be installed for the development and implementation of RadaR. To build RadaR as a Web-based software app, we used the Shiny package for R [23]. Shiny allows R users to build interactive Web apps without extensive knowledge in Web design and its programming languages. The Web apps can be run and hosted on the Web for free [24], as well as on local or cloud-based servers or on personal computers.

The functionality of R can be easily extended by installing additional packages. All packages used for the development of RadaR are listed in Table 1. RadaR is developed in an open-source environment and licensed under GNU General Public License v2.0 [25], giving options to change, modify, and adapt RadaR to both personal and commercial users’ needs while requiring the need to document code changes [25].

RadaR’s calculations and data aggregation are done reactively on the basis of the selection of the user. Single observations on the patient level build the basis for any calculation. RadaR uses common CSV files as input. A total of 3 different data sources are read in RadaR for admission, antimicrobial, and microbiological data, which are merged and transformed upon start. A patient number or study number is used as a unique identifier. All antimicrobial and microbiological data are checked to ascertain whether they fall in the interval of admission dates.

Table 1. Required R packages for RadaR.
R packageMinimal version
Table 2. Input variables for RadaR.
Admission data

adm_end_dateDischarge datea

adm_idAdmission ID


adm_start_dateAdmission datea

birth_dateBirth datea

death_during_admIn-hospital death (TRUE/FALSE)


idPatient ID or study ID

specialtyGeneral specialty (internal medicine, surgery, and other)

Antimicrobial data

ab_routeAdministration route

ab_start_dateStart of antimicrobiala

ab_stop_dateStop of antimicrobiala

atc_codeFifth level of the World Health Organization Anatomical Therapeutic Chemical (WHO ATC) classification systemb

ddd_per_dayDefined daily dose of antimicrobial according to WHO ATC classification system per dayb

idPatient ID or study ID
Microbiological data

antimicrobial susceptibility testingSeveral columns of tested antimicrobial agents (eg, amoxicillin, ciprofloxacin) with resistance results (R/I/S)

idPatient ID or study ID

materialTest material

moMicrobial ID (if test=positive)c

specialtyOrdering specialty

test_dateTest datea


bAs available on the website [31].

cAs defined by the AMR package for R [30].

The input data should be structured in a dataset format, where each variable is 1 column and each observation is 1 row. This follows the concept of “tidy data,” as defined by Hadley Wickham [26]. Table 2 displays the set of variables underlying RadaR’s functionality. In our setting for the development of RadaR, these variables originated from 3 different data sources: administrative data from the hospital data warehouse, microbiological data from the laboratory information system, and antimicrobial prescription data from the computerized prescriber order entry system. The data preparation and cleaning process are very specific for each data source, dependent on local data standards, and difficult to generalize. Therefore, Table 2 represents the final variables and formats for the analysis and use with RadaR, referring to the “tidy data” concept above and to the tidyverse R package collection for the preparation process [26,27]. Additional variables are calculated and transformed using the packages lubridate and zoo for time points and intervals, and AMR for antimicrobial (group) names, microbial isolate names, first isolate identification, and resistance analysis [28-30]. Microbiological resistance is calculated per antimicrobial substance or as coresistance if more than 1 substance is selected.

RadaR can be used for graphical exploratory data analysis. Differences in LOS are displayed by a Kaplan-Meier curve in conjunction with a log-rank test, using the survminer package [32]. Time trends for number of admissions, antimicrobial consumption, and resistance counts per year, quarter, or month, are visualized in run charts using the qicharts2 package [33]. Nonrandom variation in these run charts is tested using Anhøj’s rules [34].

RadaR has been developed in macOS High Sierra (1.4 GHz, 4 GB RAM), and it was successfully tested in Windows 7 (3.2 GHz, 8 GB RAM) and Linux (Ubuntu 16.04.4 LTS, 3.4 GHz, 12 GB RAM). A running example version has been deployed to, a publicly available Web hosting service for R Shiny apps [35]. The entire source code of RadaR is freely accessible on GitHub [36]. We intend to integrate suggestions and feedback coming from its users and the R community. RadaR was developed using data of patients admitted to the University Medical Center Groningen, Groningen, the Netherlands. Data were collected retrospectively, and permission was granted by the ethical committee (METc 2014/530). RadaR can be used locally in protected environments or hosted on the Web, provided appropriate measures have been taken to guarantee data protection, depending on national regulations.


We have developed RadaR, a Web-based software app providing an intuitive platform for rapid analysis of large datasets containing information about patients’ admission, antimicrobial use, and results of microbiological diagnostic tests. This software app can help users (ie, AMS team members) find answers to questions, such as “What are the most commonly used antimicrobials at an institution/specialty/department and have they changed over time?,” “Were adequate microbiological diagnostics performed at the start of antimicrobial treatments?,” “What are the most frequent microorganisms found and their resistance patterns in different departments?,” and “Can we identify priority areas within a hospital where antimicrobial or microbiological diagnostic use has the largest room for improvement?”

Application Design

RadaR is designed in the form of a Web browser–based dashboard that most users are familiar with from typical websites and Web-based tools (see Figure 1). The basis of RadaR’s functionality is filtering datasets and producing analytical graphs according to selection criteria defined by the user. Any calculations and data aggregation are based on single observations of individual patients. To identify and analyze groups of patients, 17 different selection criteria can be found in the sidebar (Table 3). The output of RadaR is grouped into 4 panels (patient, antimicrobials, diagnostics, and outcome) that each comprise 3 to 4 output boxes displaying the results (see Multimedia Appendix 1).

All output is based on the selection criteria defined by the user in the sidebar. Each new selection and any change need to be confirmed by clicking the confirm selection button (see Figure 1). Users can navigate among the different analysis panels by clicking the respective button.

Figure 1. Application design.
View this figure
Table 3. Selection criteria in sidebar.
Tab name and criteriaFunctionality

Start of antimicrobials (in relation to start of admission)Select patients starting treatment in a defined time period

Minimum duration of treatment (days)—all antimicrobialsSelect patients with a minimum treatment duration

Minimum duration of prescription (days)—single antimicrobialDefine the minimum duration of a prescription for any selected antimicrobial

Administration routeIntravenous or oral

First antimicrobial onlyFilter patients for first prescribed antimicrobial only or any (on the basis of all other selection criteria)

Groups of antimicrobialsFourth level of the World Health Organization Anatomical Therapeutic Chemical (WHO ATC) classification systema

AntimicrobialsFifth level of the WHO ATC classification systema

GenderFemale or male

AgeAs available in the data

YearYears available in the data

SpecialtyInternal medicine, surgery, or other

Minimum number of patients per subspecialty0, 10, 100, 1000, or 10,000

Include only this subspecialtyAll other subspecialties will be excluded

Exclude subspecialtyDefine single subspecialties to be excluded

Origin at admissionAs available in the data

Type of diagnosticsBlood culture or urine culture test

Days to first test (in relation to start of antimicrobials)Define time period for tests to be performed in

aAs available on the website [31].

Results are shown in bar charts, density plots, run charts, a bubble plot, and a Kaplan-Meier curve for LOS in hospital. Each panel further displays a table summarizing the respective data analyses. All output boxes and their content are described in Table 4. Most output boxes include modification options that can be identified by small gear icons (see Figure 1). These clickable icons allow for further specification of the generated plots and tables. Users can compare different groups (eg, antimicrobial use by antimicrobial agent, resistance patterns per isolate, or LOS by specialty) or modify the plots (eg, switch from count to proportion, change the chart type, or show or hide the legend). Plots and tables can be downloaded through download buttons as PNG files for plots and CSV, Excel, or PDF files for tables.

Finally, 2 datasets (antimicrobial/admission data and microbiological data) of the user-defined selection can be downloaded from the sidebar menu in a CSV-file format for further analysis (eg, retrieving a list of patient numbers of the selected patient group).

Table 4. Output boxes for analysis results.
Output panel and output boxOutput typeContentModification options

Subspecialties in selectionBubble chartaPatients per subspecialtyShow top 10 by number of patients

Subspecialties—tableTableTotal number of patients and per subspecialtyb

Patient ageDensity plot (distribution)Age distribution in selectionGroup by gender

Number of admissionsRun chartCount of admissions per time periodPer year, per quarter, or per month

AntimicrobialsBar chart(Group of) antimicrobials sorted by prescription, DDDc, or DOTdSingle antimicrobials or groups; select prescription count, DDD, or DOT per 100 bed days
DDDRun chartDDD per 100 bed days per group and per time periodGroup by none, specialty, subspecialty, and origin; per year, per quarter, and per month
DOTRun chartDOT per 100 bed days per group and per time periodGroup by none, specialty, subspecialty, and origin; per year, per quarter, and per month
DDD/DOT tableTableSummary of DDD/DOT per 100 bed days per groupDDD or DOT
per 100 bed days; group by antimicrobial (group), year, specialty, subspecialty, and origin

Diagnostics in selected patientsBar chartDiagnostics taken versus not taken in specified timespanCount or proportion; per year, quarter, or month
Timing of selected diagnosticsBar chartTime of diagnostics performed in days after start of treatmentb
Diagnostics in relationBar chartAbsolute difference from average proportion of selected diagnostics performedGroup by antimicrobial (group), year, specialty, subspecialty, and origin

Table—proportion performedTableSummary of proportion of diagnostics performedGroup by antimicrobial (group), year, specialty, subspecialty, and origin
First isolates in selected diagnosticsBar chartFirst isolates of microorganisms sorted by frequencyGroup by antimicrobial (group), year, specialty, subspecialty, and origin; zoom to select more or less isolates shown in graph

First isolates—tableTableFrequency table of first isolatesGroup by year, specialty, subspecialty, and origin

Resistance analysisBar chartCount or proportion of resistance or coresistance to selected antimicrobials in selected isolates in “R,” “S,” and “I” categoriesSelect isolates; select antimicrobials; group by year, specialty, subspecialty, and origin; select count or proportion

Resistance—over timeRun chartCount of resistance or coresistance to selected antimicrobials in selected isolates in “R,” “S,” and “I” categories over timeSelect isolates; select antimicrobials; per year, per quarter, or per month

TableTableCount or proportion of resistance or coresistance to selected antimicrobials in selected isolates in “R,” “S,” and “I” categoriesGroup by year, month, quarter, specialty, subspecialty, and origin; select isolates; select antimicrobials; select count or proportion

Length of stayDensity plot or histogramDistribution of length of stay per groupGroup by all, gender, year, antimicrobial (group), diagnostics performed, specialty, subspecialty, and origin; show histogram; show legend; spread out to remove overlaps
Length of stay—Kaplan-MeierKaplan-Meier curveKaplan-Meier curve per groupGroups shown as selected in the length-of-stay box
Length of stay—tableTableSummary of length of stay per groupGroup by gender, year, antimicrobial (group), diagnostics performed, specialty, subspecialty, and origin

aInteractive plot showing additional information when hovering over plot.

bNot applicable.

cDDD: defined daily doses.

dDOT: days of therapy.

Development Process

RadaR has been developed in close contact with the AMS team and senior consulting specialists at the University Medical Center Groningen, Groningen, the Netherlands, to meet the needs and requirements of this user group. Subsequently, all members of the European Society of Clinical Microbiology and Infectious Diseases Study Group for Antimicrobial Stewardship (ESGAP) were asked to evaluate and test the software app through a running Web-based example of RadaR and by filling out a Web-based survey. The ESGAP comprises around 200 members from more than 30 countries worldwide. A total of 12 members from 9 different countries took part in the evaluation. This yielded important information on user experiences with the software app, which in turn led to further improvements that are reflected in the version we presented in this report. In a next phase, RadaR will be tested in different settings of ESGAP members and other interested partners using locally available data (eg, an 837-bed tertiary care hospital in the Netherlands and a 750-bed tertiary care hospital in Greece).


RadaR was developed and tested with a dataset of all patients admitted to our institution, a 1339-bed academic tertiary referral hospital, within the years of 2009 to 2016, comprising over 180,000 admissions. For simulation purposes and Web-based user testing, we have created a test dataset of 60,000 simulated patients. This sample dataset allows testing of RadaR’s functionality, but it does not produce meaningful results.

A typical example workflow with RadaR comprises 6 steps (with examples from the test dataset). They are listed below:

  1. Define the selection: For example, patients receiving intravenous second- or third-generation cephalosporins as first treatment for at least 2 days, starting within the first 2 days of hospital admission from any specialty in all years in the dataset.
  2. Patients’ panel: Identify the total number of patients and the subspecialties with the highest number of included patients (eg, 537 patients selected in total, with 97 patients from internal medicine). Investigate patients’ gender and age distribution.
  3. Antimicrobials panel: Identify the total use of the initial cefuroxime treatment in DDD and DOT per 100 bed days (eg, 4.51 and 1.5, respectively). Stratify the results by subspecialty and identify the highest number of DDD and DOT per 100 bed days (eg, highest use by DDD and DOT in internal medicine).
  4. Diagnostics panel: Check if the selected microbiological diagnostic test (eg, blood culture test) has been performed on the same day as the start of the treatment (defined in the sidebar). Investigate the proportion of tests performed over the years and investigate which subspecialty performs best compared with others (eg, Pediatrics). Check which microorganisms (as first isolates) were found in the selected diagnostic specimens (the most common isolate: Escherichia coli). Investigate the proportion of isolates resistant to cefuroxime (8.9%) and analyze the trend over time.
  5. Outcome panel: Check for patterns of differences in LOS in the defined patient group by subspecialties or performed diagnostics (eg, highest mean LOS of 7.8 days in Surgery).
  6. Refine the selection: Investigate a subgroup of the original selection. For example, select only the top 3 subspecialties by number of patients and repeat step 2 to 5.


For setting up RadaR in a new environment after data preparation, users only need to perform the following 4 steps:

  1. Downloading R and RStudio [21,22], which are free to use and open-source software
  2. Download or copy and paste RadaR’s source code [36] into 3 files in RStudio—global.R, server.R, and ui.R
  3. In global.R, manually edit the paths for the prepared datasets to be imported into RadaR
  4. Run the app in RStudio with the calling the function runApp() in the console or by clicking the green run app button. This will download and install the required R packages needed for the app if they have not been installed previously, and this will create the final dataset for analysis. The RadaR interface will open in the RStudio viewer pane or in a new window of the standard browser of the user’s operating system.

RadaR’s appearance has been customized using a cascading style sheets (CSS) script [37] that is loaded into the app upon its start. This script needs to be saved into a subdirectory of the directory of the 3 main files (global.R, server.R, and ui.R) called “www.” We recommend RStudio’s project function to create a single project for RadaR and to store all information in this project directory. Users with experience in using CSS can fully alter RadaR’s design by changing the underlying CSS script.

Principal Findings

We have developed a Web-based software app for rapid analysis of diagnostic and antimicrobial patterns that can support AMS teams to tailor their interventions. It has been designed to enhance communication of relevant findings while being easy to use. This also applies to users without extensive prior software skills, as it follows usual Web browser user experiences. Moreover, it has been developed using open-source software. It is therefore free to use and accessible for download. In our experience, this system can be adapted to new settings within 1 day, when the required data (Table 2) are available.

Commercial software for infection management is available (eg, Epic Antimicrobial Stewardship Module, TREAT Steward). These offer extensive options for filtering, analyzing, and visualizing EHRs with real-time connections to hospital data infrastructures and have been shown to be useful in clinical practice [38]. However, it is difficult to compare functionalities of these tools because of their non–open-source nature. This fact, along with the required budget to purchase the software, drastically limits their use. We are convinced that transparent software development can support the adoption of data-driven developments while enhancing optimal quality of care and patient safety, which is crucial in the light of new data-driven developments of using EHRs [39,40].

The global nature of infections further calls to develop software tools applicable in resource-limited settings [41]. Open-source approaches for data analysis, such as RadaR, have advantages over traditional methods, such as Excel or SPSS. Hughes et al described those in their report of a software app for RNA-sequencing data analysis [15]. They highlight aspects that were also fundamental for the development of RadaR. First, R allows transparent, reproducible, and sustainable data analysis through scripts that can easily be shared and changed. This can build the basis for collaboration, and this enforces the spirit of open science (also through the strong collaborative R community on the Web). Second, R is open source and free to use; therefore, it also enables use in resource-limited settings. Finally, Shiny empowers users to interact with the data, making even very large datasets quickly interpretable.

Innovative approaches used in supporting infection management by leveraging EHRs are being investigated [17-19]. Reporting on AMR, antimicrobial use, and hospital infections (eg, for quality assurance) is well established, but it is important to integrate these data sources in an approach that allows detailed filtering options on all input. Merely looking at antimicrobial use alone or comparing aggregated results (eg, total amount of a specific antimicrobial substance per hospital correlated with the total count of a resistant isolate) will result in loss of information or even misleading interpretation. Detailed data and calculations on the basis of each individual patient are crucial to draw informed conclusions. Unfortunately, the abovementioned infection management approaches [17-19] either depend on additional commercial software for data visualization or the source code is not openly available. We want to encourage others to turn toward available open-source software solutions, such as R, for an increased potential of collaboration and transparency. However, their strength is the connection to real-time data flows. This enables the prospective use and increases their usability for daily clinical practice. RadaR is currently still limited to retrospective data analysis because of a changing hospital data infrastructure in our setting. Technically, it is feasible to connect R-based software apps such as RadaR to real-time hospital data infrastructures running with clinical data standards [42]. For a start, access to static data extraction is often easier and faster to achieve. RadaR can be used to advocate the use of data visualization tools and improved accessibility of hospital data sources. Until connection to real-time hospital data is established, RadaR can support users as a stand-alone option for retrospective data analysis in infection management. Next steps will involve testing in multiple settings and forming a user and research group to continue and expand the use of open-source technology and open science principles in infection management.


RadaR demonstrates the feasibility of developing software tools for infection management and AMS teams in an open-source approach, making it free to use, share, or modify according to various needs in different settings. RadaR has the potential to be a highly useful tool for infection management and AMS in daily practice.


The authors would like to thank the ESGAP executive committee for supporting the evaluation of RadaR in the ESGAP study group and all its members for their valuable input, suggestions, and comments. Furthermore, the authors wish to thank Igor van der Weide, Jan Arends, and Prashant Nannan Panday for their great support in obtaining required data at our institution that built the basis for the development of RadaR. The authors also thank the online R community as well as the valuable comments, suggestions, and input from reviewers that they have received to improve RadaR.

RadaR was developed as part of a project funded by the European Commission Horizon 2020 Framework Marie Skłodowska-Curie Actions (grant agreement number: 713660-PRONKJEWAIL-H2020-MSCA-COFUND-2015).

Conflicts of Interest

None declared.

Multimedia Appendix 1

Screenshot of RadaR.

MOV File, 6MB


  1. Dyar OJ, Huttner B, Schouten J, Pulcini C, ESGAP (ESCMID Study Group for Antimicrobial stewardshiP). What is antimicrobial stewardship? Clin Microbiol Infect 2017 Nov;23(11):793-798 [FREE Full text] [CrossRef] [Medline]
  2. Barlam TF, Cosgrove SE, Abbo LM, MacDougall C, Schuetz AN, Septimus EJ, et al. Implementing an Antibiotic Stewardship Program: guidelines by the Infectious Diseases Society of America and the Society for Healthcare Epidemiology of America. Clin Infect Dis 2016 May 15;62(10):e51-e77. [CrossRef] [Medline]
  3. Davey P, Marwick CA, Scott CL, Charani E, McNeil K, Brown E, et al. Interventions to improve antibiotic prescribing practices for hospital inpatients. Cochrane Database Syst Rev 2017 Dec 9;2:CD003543. [CrossRef] [Medline]
  4. National Institute for Health and Care Excellence. Antimicrobial stewardship: systems and processes for effective antimicrobial medicine use   URL: [accessed 2018-11-16] [WebCite Cache]
  5. Schuts EC, Hulscher ME, Mouton JW, Verduin CM, Stuart JW, Overdiek HW, et al. Current evidence on hospital antimicrobial stewardship objectives: a systematic review and meta-analysis. Lancet Infect Dis 2016 Jul;16(7):847-856. [CrossRef] [Medline]
  6. Stichting Werkgroep Antibiotica Beleid. 2016. SWAB Guidelines for Antimicrobial Stewardship 2016   URL: http:/​/www.​​swab/​cms3.nsf/​uploads/​FAF701FBF4FCBDD6C12580EC0037D292/​$FILE/​20161228%20SWAB%20Guidelines%20for%20Antimicrobial%20Stewardship%20-definitief.​pdf [accessed 2018-11-16] [WebCite Cache]
  7. Pulcini C, Binda F, Lamkang AS, Trett A, Charani E, Goff DA, et al. Developing core elements and checklist items for global hospital antimicrobial stewardship programmes: a consensus approach. Clin Microbiol Infect 2018 Apr 3:20-25. [CrossRef] [Medline]
  8. Sarkies MN, Bowles K, Skinner EH, Mitchell D, Haas R, Ho M, et al. Data collection methods in health services research: hospital length of stay and discharge destination. Appl Clin Inform 2015;6(1):96-109 [FREE Full text] [CrossRef] [Medline]
  9. British Society for Antimicrobial Chemotherapy. Birmingham, United Kingdom: British Society for Antimicrobial Chemotherapy; 2018. Antimicrobial stewardship: From Principal to Practice   URL: [accessed 2018-11-16] [WebCite Cache]
  10. Pulcini C, Morel CM, Tacconelli E, Beovic B, de With K, Goossens H, et al. Human resources estimates and funding for antibiotic stewardship teams are urgently needed. Clin Microbiol Infect 2017 Nov;23(11):785-787 [FREE Full text] [CrossRef] [Medline]
  11. Howard P, Pulcini C, Levy Hara G, West RM, Gould IM, Harbarth S, ESCMID Study Group for Antimicrobial Policies (ESGAP), ISC Group on Antimicrobial Stewardship. An international cross-sectional survey of antimicrobial stewardship programmes in hospitals. J Antimicrob Chemother 2015 Apr;70(4):1245-1255. [CrossRef] [Medline]
  12. Dik JH, Poelman R, Friedrich AW, Panday PN, Lo-Ten-Foe JR, van Assen S, et al. An integrated stewardship model: antimicrobial, infection prevention and diagnostic (AID). Future Microbiol 2016;11(1):93-102 [FREE Full text] [CrossRef] [Medline]
  13. Staib A, Sullivan C, Jones M, Griffin B, Bell A, Scott I. The ED-inpatient dashboard: Uniting emergency and inpatient clinicians to improve the efficiency and quality of care for patients requiring emergency admission to hospital. Emerg Med Australas 2017 Jun;29(3):363-366. [CrossRef] [Medline]
  14. Smith CM, Hayward AC. DotMapper: an open source tool for creating interactive disease point maps. BMC Infect Dis 2016 Apr 12;16:145 [FREE Full text] [CrossRef] [Medline]
  15. Hughes LD, Lewis SA, Hughes ME. ExpressionDB: an open source platform for distributing genome-scale datasets. PLoS One 2017;12(11):e0187457 [FREE Full text] [CrossRef] [Medline]
  16. GitHub.   URL: [accessed 2018-11-16] [WebCite Cache]
  17. Simpao AF, Ahumada LM, Larru Martinez B, Cardenas AM, Metjian TA, Sullivan KV, et al. Design and implementation of a visual analytics electronic antibiogram within an electronic health record system at a tertiary pediatric hospital. Appl Clin Inform 2018 Dec;9(1):37-45. [CrossRef] [Medline]
  18. Lesho EP, Waterman PE, Chukwuma U, McAuliffe K, Neumann C, Julius MD, et al. The antimicrobial resistance monitoring and research (ARMoR) program: the US Department of Defense response to escalating antimicrobial resistance. Clin Infect Dis 2014 Aug 1;59(3):390-397. [CrossRef] [Medline]
  19. Simões AS, Maia MR, Gregório J, Couto I, Asfeldt AM, Simonsen GS, et al. Participatory implementation of an antibiotic stewardship programme supported by an innovative surveillance and clinical decision-support system. J Hosp Infect 2018 Nov;100(3):257-264. [CrossRef] [Medline]
  20. Molloy JC. The Open Knowledge Foundation: open data means better science. PLoS Biol 2011 Dec;9(12):e1001195 [FREE Full text] [CrossRef] [Medline]
  21. RStudio.   URL: [accessed 2018-11-16] [WebCite Cache]
  22. R Core Team. R: A Language and Environment for Statistical Computing.   URL: [accessed 2018-11-16] [WebCite Cache]
  23. Chang W, Cheng J, Allaire JJ, Xie Y, McPherson J. The Comprehensive R Archive Network. shiny: Web Application Framework for R   URL: [accessed 2018-11-16] [WebCite Cache]
  24.   URL: [accessed 2018-11-16] [WebCite Cache]
  25. Stallman R. GNU General Public License, version 2. 1991.   URL: [accessed 2018-11-16] [WebCite Cache]
  26. Wickham H. Tidy data. J Stat Soft 2014;59(10):23. [CrossRef]
  27. Wickham H. tidyverse: Easily Install and Load the 'Tidyverse'. 2017.   URL: [accessed 2019-02-28] [WebCite Cache]
  28. Grolemund G, Wickham H. Dates and times made easy with lubridate. J Stat Soft 2011;40(3):25. [CrossRef]
  29. Zeileis A, Grothendieck G. zoo: S3 infrastructure for regular and irregular time series. J Stat Soft 2005;14(6):27. [CrossRef]
  30. Berends MS, Luz CF, Glasner C, Friedrich AW, Sinha B. GitLab. AMR: An R package to simplify the analysis and prediction of Antimicrobial Resistance (AMR) and work with antibiotic properties by using evidence-based methods   URL: [accessed 2019-05-09] [WebCite Cache]
  31. WHO Collaborating Centre for Drug Statistics Methodology. Oslo, Norway; 2018. Guidelines for ATC classification and DDD assignment   URL: [accessed 2018-11-16] [WebCite Cache]
  32. Kassambara A, Kosinski M. The Comprehensive R Archive Network. 2018. survminer: Drawing Survival Curves using 'ggplot2'   URL: [accessed 2018-11-16] [WebCite Cache]
  33. Anhoej J. The Comprehensive R Archive Network. 2018. qicharts2: Quality Improvement Charts   URL: [accessed 2019-03-11] [WebCite Cache]
  34. Anhøj J. Diagnostic value of run chart analysis: using likelihood ratios to compare run chart rules on simulated data series. PLoS One 2015;10(3):e0121349 [FREE Full text] [CrossRef] [Medline]
  35. RadaR   URL: [accessed 2018-11-16] [WebCite Cache]
  36. RadaR GitHub.   URL: [accessed 2018-11-16] [WebCite Cache]
  37. RadaR CSS GitHub.   URL: [accessed 2018-11-16] [WebCite Cache]
  38. Pettit N, Han Z, Choksi A, Bhagat P, Pisano J. Using the Epic® Antimicrobial Stewardship (ASP) module to optimize antimicrobial stewardship interventions. Open Forum Infect Dis 2017;4(suppl_1):S263-S264. [CrossRef]
  39. Xiao C, Choi E, Sun J. Opportunities and challenges in developing deep learning models using electronic health records data: a systematic review. J Am Med Inform Assoc 2018 Oct 1;25(10):1419-1428 [FREE Full text] [CrossRef] [Medline]
  40. Pirracchio R, Cohen MJ, Malenica I, Cohen J, Chambaz A, Cannesson M, ACTERREA Research Group. Big data and targeted machine learning in action to assist medical decision in the ICU. Anaesth Crit Care Pain Med 2018 Oct 16:-. [CrossRef] [Medline]
  41. Hahn E, Blazes D, Lewis S. Understanding How the. Health Secur 2016;14(1):13-18. [CrossRef] [Medline]
  42. Hong N, Prodduturi N, Wang C, Jiang G. Shiny FHIR: an integrated framework leveraging Shiny R and HL7 FHIR to empower standards-based clinical data applications. Stud Health Technol Inform 2017;245:868-872 [FREE Full text] [Medline]

AMR: antimicrobial resistance
AMS: antimicrobial stewardship
CSS: cascading style sheets
DDD: daily defined doses
DOT: days of therapy
EDs: emergency departments
EHR: electronic health record
ESGAP: European Society of Clinical Microbiology and Infectious Diseases Study Group for Antimicrobial Stewardship
LOS: length of stay
RadaR: Rapid analysis of diagnostic and antimicrobial patterns in R

Edited by G Eysenbach; submitted 17.11.18; peer-reviewed by A Staib, J van Gemert-Pijnen; comments to author 27.02.19; revised version received 12.03.19; accepted 24.03.19; published 24.05.19


©Christian Friedemann Luz, Matthijs S Berends, Jan-Willem H Dik, Mariëtte Lokate, Céline Pulcini, Corinna Glasner, Bhanu Sinha. Originally published in the Journal of Medical Internet Research (, 24.05.2019.

This is an open-access article distributed under the terms of the Creative Commons Attribution License (, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work, first published in the Journal of Medical Internet Research, is properly cited. The complete bibliographic information, a link to the original publication on, as well as this copyright and license information must be included.