This repository contains some examples of how to use SQL with python and jupyter notebook
-
CrimesRatesForPubsAroundGoldsmiths.ipynb The notebook is used to compute the crime rates around pubs using data from: https://un5n601ugjcvqgtphkc2e8r.julianrbryant.com/ and https://un5gmtkzghebwnd6rqx28.julianrbryant.com/open-pubs/london. The map with the results can be found here: https://un5gmtkzgjfbpmm5pm1g.julianrbryant.com/maps/d/u/0/edit?hl=it&hl=it&mid=19uIqMzanBu69XsLNsjlJsO4zopMML2uo&ll=51.473514041170944%2C-0.03435662565607345&z=13
-
ScrapingCocktailDatasets.ipynb The notebook is used to pre-process the data from https://un5gmtkzgjjcgj20h4v2jm2gk0.julianrbryant.com/api.php. The JSON file with all the data has been downloaded from https://github.com/VincentRbbmnd/cocktail-scraper
-
TemplateToRunQuery.ipynb The notebook is a template used to query an RDS instance on Amazon (is no longer available)
-
data It is a folder with all the data, and the backup of the database, that can be imported in PostgresSQL
-
SQLPrimer.pdf It is a presentation used to explain SQL operators like join, cartesian product, group by, having, select * from * where *. Some examples have been taken from https://umndmzagmyzzjk6gm3c0.julianrbryant.com/class/cs145/