The data has been normalised manually into one table and imported as follows:
library(xlsx)
ethopia_schooling_youngOld <- read.csv(file = "data/ethopia_education_schooling_young-old-comparison.csv")
This is a very simple plotly visualisation of the percentage of students in school across the different regions of Ethiopia:
ethopia_schooling_region <- ethopia_schooling_youngOld[ethopia_schooling_youngOld$Property.Type == "schooling region",]
library(plotly)
plot_ly(data = ethopia_schooling_region,
type = "bar",
x = Property,
y = percentage.in.school,
group = Cohort) %>%
layout(xaxis = list(title = ""),
yaxis = list(title = "Percentage in School"))
I built a small Shiny app for pivoting throught the data, embedded below: