Analytical – Honest – Passionate
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 …
Some CSV files have issues with them. Below is a code snippet to save the information in a csv file into a duckdb database, ignoring all the ‘broken’ rows.
Pandas is the go to library in Python for analysing and manipulating data. This post lists some useful video resources for learning this package. Brandon Rhodes – Pandas From The …
An example of how to run multiple queries in parallel.
A lightweight example of saving some logs to an SQLite database in a python script.
A short guide to adding user authentication to Streamlit apps. So you’ve created a beautiful Streamlit app which your users love, but only certain people should be able to access …