After the implementation of the Local Code of 2018, government institutions and independent organizations in Tunisia such as Al-Bawsala begin publishing data at the Municipal Level, closest political unit to the citizen (n=350). Other organizations, such as Arab-Barometer continue publishing data at the level of delegations, closest administrative unit (n=264). This leads to complications among scholars who would like to examine data at the local level. Furthermore, local organizations tend to publish information with Arabic municipality names, whereas international organizations code delegations with Latin characters. Hence, manually matching the codes can be tedious as some delegations have multiple municipalities within.
In this page, I share the R Studio Code and sample excel files for merging the data at the level of delegation and municipalities. You may find the Excel Table of municipalities per delegation that I constructed and the Al-Bawsala Transparency Data on municipalities below:
You may use the R-Studio code to merge the Al-Bawsala data on Municipalities with the data at the level of Delegations:
You may then utilize this data to graph the average values of municipalities within the same delegation. For instance, I graphed below the average values for Al-Bawsala’s transparency score:
If you would like to learn how to make graphs on Tunisia map, I encourage you to visit Professor Malouche’s website. If you have questions or would like to make corrections, e-mail me at firstname.lastname@example.org