Analytical – Honest – Passionate
A short guide on installing and authorising gcloud on ubuntu 26.04 LTS. gcloud is a command line tool that allows you to interact with Google Cloud Platform services such as …
A small collection of basic cypher commands so I don’t have to Google them everytime. Count how many nodes of a type there are Create a named index See the …
Recently I attended Measurecamp Melbourne and gave an introductory talk about data testing. In it I covered the different types of “bad data” and some tools and approaches to test …
A short example of how to load data that is in a sheet in an excel file into a DuckDB database saved on disk using python.
In a previous post we used sweetviz to make a summary of a csv file, and ydata profiling to compare 2 different csv files. Well Sweetviz can also be used …
On this blog I self host Umami analytics to help me keep an eye on how many visitors come and which pages and types of content are most popular. I …
When using SQLfluff to format sql files it is possible to set certain formatting rules that should be followed when formatting the the files. These rules can be specified in …
SQL is a very flexible language when it comes to formatting. As long as the commands and syntax are in the right order then the SQL query will work. Whitespace …
Below is a python script that uses the ydata-profiling library to create a report that compares two csv files. This is proving useful in verifying the similarity between original and …
A previous post showed how to set a ‘daily query usage‘ quota in BigQuery, and what that quota should be to stay within the free tier of BigQuery. Well, what …