Analytical – Honest – Passionate
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 …
In BigQuery there is a free tier for querying data. As long as less than 1 tebibyte of data is queried in a month there are no charges associated with …
SQLite is a great choice for doing data analytics locally. SQLite is a robust database that has been battle tested for over a decade. It is a single file which …
Videos about genetic algorithms from the Nature of Code playlist from “The Coding Train” YouTube channel. Nature of Code genetic algorithm section.