C25, C31 Impfwilligkeit analysieren

⛶  Open fullscreen
C31 Impfwilligkeit analysieren
Data Hackdays BE 2021 Ask

Was könnte die Impfwilligkeit wirklich erhöhen?

C25 Impfwilligkeit analysieren
Data Hackdays BE 2021 Ask

Impfwilligkeit analysieren

This content is a preview from an external site.

DataHackDayBern2021

Dataanalyse zur Impfwilligkeit im Kanton Bern

timeline

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

Joined the team

18.11.2021 17:29 ~ christoph_betschart

Event finished

13.11.2021 14:30

Edited content

13.11.2021 13:40 ~ TheCell

Repository updated

13.11.2021 13:39 ~ TheCell

add monthly distance data (@hackcbe)

gathering all the data and preparing for the presentation

13.11.2021 12:42 ~ TheCell

moved media

moved data garbage

added screenshots of failed attempts

Edited content

13.11.2021 11:13 ~ Andrea

visualisation with political parties (@Luca Liechti)

Eigenimpscore.sql (@Lukas)

Fancy per-party plots (@Luca Liechti)

add grafana plugin (@rbcb-bedag)

tried react with leaflet

add DataPublic/eigenimpfscoredata.json (@Lukas)

update data schema (@hackcbe)

add erstimpf distanz pro gemeinde over all time (@hackcbe)

mehr generated (@Lukas)

open layers, leaflet, react, angular alles probiert, nichts geht. Noice

13.11.2021 09:41 ~ TheCell

still nothing works :)

add events dashboard (@hackcbe)

map test projects, only openlayers-app is semi working

Secret genius hack made results much worse.

12.11.2021 21:39 ~ luca_liechti

First regression (@Luca Liechti)

changed gemeindeportraits, first version of regression almost done

Volle Konzentration in der Übersetzer*innenkabine

12.11.2021 20:26 ~ luca_liechti

open map nichts geht mit vanillajs <3

12.11.2021 20:20 ~ TheCell

renaming (@rbcb-bedag)

removed z-index from geojson

crs type of map defined

map generation

ol map working

Gemeindeportraits als csv (@Luca Liechti)

added Eigenimpfscore (@Lukas)

late night standup

12.11.2021 19:17 ~ luca_liechti

leaving for dinner with the bois

12.11.2021 18:01 ~ luca_liechti

Merge branch 'main' of https://github.com/TheCell/DataHackDayBern2021 into main (@Luca Liechti)

Repository updated

12.11.2021 16:14 ~ Andrea

generation inserts for gemeinde inzidenzen (@rbcb-bedag)

Edited content

12.11.2021 15:41 ~ TheCell

A basic frontend website is working with bootstrap and the d3.js library. No idea if we will use it or not yet

12.11.2021 15:40 ~ TheCell

Repository updated

12.11.2021 15:39 ~ TheCell

Eigenimpfungs Score ermitteln :)

12.11.2021 15:37 ~ lu_pe

crying

12.11.2021 15:36 ~ luca_liechti

Joined the team

12.11.2021 15:36 ~ luca_liechti

Repository updated

12.11.2021 15:35 ~ TheCell

Repository updated

12.11.2021 15:33 ~ TheCell

Joined the team

12.11.2021 15:33 ~ TheCell

Challenge posted

12.11.2021 15:33 ~ TheCell

postgres docker starting script added (@rbcb-bedag)

gemeinde protrait sql ddl and inserts added

most of d3 working

Merge branch 'main' of github.com:TheCell/DataHackDayBern2021 into main (@rbcb-bedag)

gemeindeportrait adjusted only to kanton bern

clean maileingaenge.xlsx (@Lukas)

add: Grafana Skript and Medienmitteilungen.csv; update Datenaufbereitung.ipynb

added basic frontend

add: Datenaufbereitungs Jupyter Notebook (@Lukas)

etl for extracting gemeinde data (@rbcb-bedag)

uignore data_private folder again

ignore only subfolders

replace gemeindeverzeichnis with correct file (@rbcb-bedag)

add gemeindeverzeichnis

add gemeinde protrait

moved communities file

Merge branch 'main' of github.com:TheCell/DataHackDayBern2021 into main

gitignore adjusted

Merge branch 'main' of https://github.com/TheCell/DataHackDayBern2021 into main (@Luca Liechti)

chore: added Public folder

Gemeinden (@Luca Liechti)

feat: added git ignore

Initial commit

Event started

12.11.2021 09:00
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.

Data Hackdays BE 2021