Analytical – Honest – Passionate
A simple tool to create dates in a date range at the terminal. Each date in the date range is printed to the screen allowing for redirection or incorporation into …
A collection of video resources to on using and understanding SQLite. SQLite case study SQLite with Python SQLite for beginners …although some of the topics don’t seem like beginner topics …
Different approaches to load data into a SQLite database using the following Python libraries: Pandas Using the pandas library (alongside click, and uv) to load a csv file into a …
Working with data involves handling a lot of data files, most commonly CSV files. It can be very helpful to do some exploratory data analysis on the CSV file to …
In case you haven’t heard, UV is a relatively new python package and project manager. UV allows for you to define package dependencies and the Python version to run the …
For those interested in the field of Digital Analytics I have put together this project based curriculum to take someone from “digital analytics curious” to having the technical skill set …
In this part of the series we will walkthrough how to set up a query to run at a regular interval using Python and Cloud Functions. This is useful particularly …
Use this Dockerfile as a template to be able to create docker images that will execute a python script once the container is run. This can be very useful if …
For a little while now I have been using a personal health tracking tool to monitor my progress in various areas such as strength exercises, weight management and mental hygiene …