#Opendatabase The script for filling and defining views on database containing open data (so far CBS data)

Data will be read into python with the cbsodata module. Then the data will be read into the mariadb Database.

Log in to database should not be pushed to GitHub.

One should create a file called credentials.py containing login = { 'user' : 'Yourusername', 'password' : 'Yourpassword' }

database = { 'host' : "URL to MariaDB database" 'DB' : 'name of database' }

To read in the bevolkingsdata, one should put the bevolkingsleeftijdsdata in the folder ./age_data with the names as defined in the file databronnen.py

To read in updates for how neighborhoods are combined in the MMR, on should add a folder Vertaling_wijken, Below that folder one should add folders for all years, per year one should then add xlsx files containing the details per municipality.