× This Challenge was posted 1 year ago

Challenge Project

C25, C31 Impfwilligkeit analysieren

⛶  Fullscreen ↓  Download 📂 Demo
C31 Impfwilligkeit analysieren
Data Hackdays BE 2021 Challenge

Was könnte die Impfwilligkeit wirklich erhöhen?

C25 Impfwilligkeit analysieren
Data Hackdays BE 2021 Challenge

Impfwilligkeit analysieren


Dataanalyse zur Impfwilligkeit im Kanton Bern


political party analysis

For the analysis with the political parties, run impfzentren.ipynb. In cell 14, set independentvar and independentpretty to the party you want to run the regression with. E.g. for SP set independent_var = 'wahl_sp' independent_pretty = 'SP' Where independentvar is one of the values from columnlist in cell 13.

NB. Theoretically you can take any value from column_list and run a linear regression with it.

communities' progress vs. the canton's

For this analysis, just run all the cells in communities.ipynb. Create a folder called "plots" first. You will receive an error message, but that is just because Jupyter can't open more than 20 figures by default. The images will still be created.

Grafana Dashboards

Create 'clean' csv files from the raw data

Put all raw csv files in the folter Data_Private/raw and run the pythonscript. python datenaufbereitung.py or use the Datenaufbereitung jupyter notebook.

Start grafana and Postgres Docker:

sh start_postgres.sh
sh start_grafana.sh

Or if you want the Map plugin: cd grafana docker-compose up

Fill the Postgres DB with data

Find an example how to do it in write_to_db_example.py We used a magic "drag and drop" tool to insert the csv data into the database. To duplicate that, you need to transform the datatype of some columns (especially dates) before writing it into the DB.

Create the Dashboards in Grafana

Load Data_Public/grafana_dashboard_save.json into grafana and adapt the queries to your database shema. Or just create a new one (is probably easier).

This content is a preview from an external site.
Contributed 2 years ago by TheCell for Data Hackdays BE 2021
Alle Teilnehmer*innen, Sponsor, Partner, Freiwilligen und Mitarbeiter*innen unseres Hackathons sind verpflichtet, dem Hack Code of Conduct zuzustimmen. Die Organisatoren werden diesen Kodex während der gesamten Veranstaltung durchsetzen. Wir erwarten die Zusammenarbeit aller Teilnehmer*innen, um eine sichere Umgebung für alle zu gewährleisten. Weitere Einzelheiten zum Ablauf der Veranstaltung finden Sie unter Richtlinien in unserem Wiki.

Creative Commons LicenceDie Inhalte dieser Website stehen, sofern nicht anders angegeben, unter einer Creative Commons Attribution 4.0 International License.