vote2json: Tool for Processing Council Voting Data

council, voting, data preprocessing, data transformation, meta model, Python

In order to be able to further process data representing real votes of representatives, any source data must be transformed into a reference data model. The aim of this work is to develop a generic tool providing such data preprocessing. The solution to the problem was to design a meta-model that can map the source data to the reference model and process the most common source data formats, i.e. CSV, XML, JSON and HTML files. Some of the missing source data can be inferred, others can be added to the dataset. The output of the processing is a JSON file that can be uploaded to a council voting visualization application, which provides the ability to browse the data in a user-friendly format. The tool has been tested on selected data from Czech municipalities and regions, and the resulting datasets are available as open datasets within the Zastupko project.

Attached file.

Contact Kristýna Zaklová (kristyna.zaklova@gmail.com).