meevans1 / portsmouthhospitaltrust Goto Github PK

Interesting repo, but I'm not sure what the Binder benefits are? eg all the notebooks require a connection to a db that is not likely to be available to anyone using the Binderised notebooks?

Also, to run the notebooks in MyBinder, you need to install package dependencies.

eg create a file binder/requirements.txt containing at least:

numpy
pandas
matplotlib
scipy
seaborn

#pyodbc

FWIW, it is possible to run a db in a Binder container. For example, run postgres in MyBinder.

Another alternative would be to grab the data from your db or show how to download the data files from the NHS opendata site and put them into something simple like sqlite, then query from there. db-to-sqlite (export tables from connected db to sqlite) and csvs-to-sqlite are handy for that, ( @simonw also has other X-to-sqlite packages available.)