Repository files navigation

This repository contains some examples of how to use SQL with python and jupyter notebook

• CrimesRatesForPubsAroundGoldsmiths.ipynbThe notebook is used to compute the crime rates around pubs using data from:https://data.police.uk/ andhttps://www.getthedata.com/open-pubs/london.The map with the results can be found here:https://www.google.com/maps/d/u/0/edit?hl=it&hl=it&mid=19uIqMzanBu69XsLNsjlJsO4zopMML2uo&ll=51.473514041170944%2C-0.03435662565607345&z=13

• ScrapingCocktailDatasets.ipynbThe notebook is used to pre-process the data fromhttps://www.thecocktaildb.com/api.php. The JSON file with all the data has been downloadedfromhttps://github.com/VincentRbbmnd/cocktail-scraper

• TemplateToRunQuery.ipynbThe notebook is a template used to query an RDS instance on Amazon (is no longer available)

• dataIt is a folder with all the data, and the backup of the database, that can be imported in PostgresSQL

• SQLPrimer.pdfIt is a presentation used to explain SQL operators like join, cartesian product, group by, having, select * from * where *.Some examples have been taken fromhttp://web.stanford.edu/class/cs145/