This codebase is used to create the two databases that power CollegeScoreCard.io. One of the databases stores app-generated data (such as messages from the website visitors), while the other stores static data (such as the information on colleges). Please visit the website/repo for more details. The codebase for the website is available here.
- CollegeScoreCard.io codebase
- Dash user guide
- Dash/Plotly community forum
- Flask -- a Python-based web framework
- The Flask Mega-Tutorial by Miguel Grinberg
- Official CollegeScoreCard dataset
-
These scripts should work with sqlite and mysql (not tested with postgre, for example). For trying it out the first time, start with sqlite (uncomment the sqlite-scpecific lines in config.py). It'll create app.db and app_data.db in the top-level folder. For working with mysql: a. Comment out the sqlite related lines in config.py, and uncomment the mysql related lines b. You need to include the credentials in the instances.py as a dictionary (a fake fake_instances.py is included). c. Create a new user in your mysql server, create new databases as you name them in your instances.py, and grant the new user all access on those databases
-
Run 'python csv_to_db.py' to create the appropriate tables in the database. If using sqilte, copy the app.db and app_data.db into the data folder of the collegescorecard app. If using mysql, make sure that the collegescorecard app has the right credentials available to access the tables you just created.
-
Run 'python access_db.py' to confirm that you can access all the tables and get the data out.
-
The requirements.txt is embarrassingly long and have modules not required for this repo. Hopefully there'll be a cleaner version soon!