plotExample1.py shows a very simple example of generating a pie chart using Matplotlib
plotExample2.py shows a very simple example of generating multiple pie charts in the same python script
plotExampleBarChart.py generates a simple bar chart using matplotlib
Using SQLite - this is an example of extracting all of the amenities in the SQLite database and printing them to the terminal/console window using Python
Using SQLite - this is an example of extracting all amenities with a specific value - in our case pub in the SQLite database
Using SQLite we create an output CSV file which contains the geographical coordinates of every amenity in the database with the value of 'pub'. This makes the visualisation of the results of this query much easier
Using SQLite we now create another CSV output file but this time we are extracting all amenity=pub and then pubs which have a specific name - that is with a name which contains the word 'Queen'
Using SQLite we now create another CSV output file but this time we are extracting all amenity=pub and then pubs which have a specific name - that is with a name which contains the word 'Tavern'. However this time the word Tavern must be found at the end of the string representing the pub name
A small variation on example4 and example4a of the SQLite examples.
A slightly more complicated example. This time we use the SQLite database to count the most popular amenities in the dataset. We then use some code from previous examples to generate a bar-chart of the output of this query