This post shows how to make a Raspberry Pi Carbon Dioxide Monitor using a raspberry pi connected to a USB carbon dioxide monitor. The project is deliberately bare bones and leaves several opportunities for refinement, improvement and general tinkering. What we are aiming to make The following schematic shows what we will be building up… Read More »
Flask is a lightweight python web framework which can used for creating RESTful APIs. This post shows you how to make a simple Docker Flask SQLite API. This post builds on the excellent Flask API Lesson on The Programming Historian. If you just want to dive straight into a Docker Flask SQLite API example you… Read More »
Joining tables in SQL is an essential part of many digital services and products. Joins let you answer questions such as which customers bought which products? How many staff work at a particular location? Which students are in which classes at a school? Joining in SQL becomes even more important when your data are stored… Read More »
The UK has around 160 universities, located around the country. Here is a map of UK University Locations, made using Folium. Download the UK university locations data [csv] Access the list of UK universities Python Code For UK University Locations How to convert postcodes to coordinates
It’s common to have the postcode of an address and need to plot this on a map. In this post I show you two options for how to convert postcode coordinates using an online tool or data available for free online. Option 1. Use an Online Conversion Tool Often the easiest way to convert postcode… Read More »