Tool for Assessing the Capacity and Capability of Basic, Preclinical, and Clinical Research Sites in Africa

Africa CDC Research Centers Capacity Assessment

This R script merges English and French survey datasets of research centers, computes composite capacity scores, and produces summary statistics and visualizations for six West African countries (Nigeria, Togo, Ghana, Guinea-Bissau, Gambia, Sierra Leone).

Loading the required libraries

library(dplyr)

## 
## Attaching package: 'dplyr'

## The following objects are masked from 'package:stats':
## 
##     filter, lag

## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union

library(maps)
library(ggplot2)

Read English and French datasets

Loading the required datasets

df_eng <- read.csv("AfricanUnionMemberSt_DATA_LABELS_2025-05-15_1437.csv", 
                   stringsAsFactors = FALSE, check.names = FALSE)
df_fr  <- read.csv("CartographieDesCapac_DATA_LABELS_2025-05-15_1447.csv", 
                   stringsAsFactors = FALSE, check.names = FALSE)

Note that the echo = FALSE parameter was added to the code chunk to prevent printing of the R code that generated the plot.

Filtering the survey responses

# Filter to completed responses only (use the 'Complete?' field)
df_eng <- df_eng[df_eng$`Complete?` == "Complete", ]
df_fr  <- df_fr[df_fr$`Complete?` == "Complete", ]