Applied result detail
vote2json: Tool for Processing Council Voting Data
JANOŠÍK, A.; ZAKLOVÁ, K.; HYNEK, J.
Original Title
vote2json: Tool for Processing Council Voting Data
English Title
vote2json: Tool for Processing Council Voting Data
Type
Software
Abstract
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.
Abstract in English
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.
Keywords
council, voting, data preprocessing, data transformation, meta model, Python
Key words in English
council, voting, data preprocessing, data transformation, meta model, Python
Location
Přiložený soubor.
Licence fee
In order to use the result by another entity, it is always necessary to acquire a license
www
Documents
Responsibility: Ing. Marek Strakoš