A command line tool to compare 2 different csv files – sweetviz edition
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 …
Bots arrive on marquinsmith.com
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 …
Jeff Booth conversation on Simply Bitcoin
Insightful discussion with Jeff Booth about the interaction between an inflationary system (fiat) and a deflationary system (bitcoin).
A `.sqlfluff` settings file I like
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 …
Setting up sqlfluff as a pre commit hook using UV
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 …
A command line tool to compare 2 different csv files
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 …