Product detail

vote2json: Tool for Processing Council Voting Data

JANOŠÍK, A. ZAKLOVÁ, K. HYNEK, J.

Product 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.

Keywords

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

Create date

4. 11. 2024

Location

Přiložený soubor.

Possibilities of use

K využití výsledku jiným subjektem je vždy nutné nabytí licence

Licence fee

Poskytovatel licence na výsledek nepožaduje licenční poplatek

www

Documents

Responsibility: Ing. Marek Strakoš