MarquinSmith

Analytical – Honest – Passionate

  • Home
  • Services
  • Mini Projects
    • Data Analytics Helper Tools
    • Bitcoin Price Dashboard
    • Journey to data engineering
    • Tarantino Film Dashboard
    • Woolworths stock price tracker
    • How to reason and argue
  • Reference
    • The BookShelf
    • SQL Cheat Sheet
    • Dockerfile Cheat Sheet
  • Health, fitness and wellbeing
    • Crossfit Workouts
    • Gymnastics
    • Strength and fitness masterclass
    • Nutrition Course
    • Workout Stats
    • Physical Activity Stats
    • 6 week pre season soccer fitness plan
  • About

Author: M Smith

Automation

A command line tool to compare 2 different csv files – sweetviz edition

4th November 20254th November 2025 M SmithLeave a comment

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 …

Read More ›
Data Analysis

Bots arrive on marquinsmith.com

3rd November 20252nd November 2025 M SmithLeave a comment

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 …

Read More ›
Personal Development

Physical Health Tracker – October 2025

2nd November 20252nd November 2025 M SmithLeave a comment
Read More ›
Finance

Jeff Booth conversation on Simply Bitcoin

27th October 202527th October 2025 M SmithLeave a comment

Insightful discussion with Jeff Booth about the interaction between an inflationary system (fiat) and a deflationary system (bitcoin).

Read More ›
Automation

A `.sqlfluff` settings file I like

26th October 202526th October 2025 M SmithLeave a comment

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 …

Read More ›
Automation

Setting up sqlfluff as a pre commit hook using UV

23rd October 202523rd October 2025 M SmithLeave a comment

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 …

Read More ›
Personal Development

Physical Health Tracker – September 2025

4th October 20253rd October 2025 M SmithLeave a comment
Read More ›
Personal Development

Physical Health Tracker – August 2025

3rd October 20253rd October 2025 M SmithLeave a comment
Read More ›
Automation

A command line tool to compare 2 different csv files

20th September 202520th September 2025 M SmithLeave a comment

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 …

Read More ›
Automation

Pre commit hooks in git YouTube resources

3rd September 2025 M SmithLeave a comment

A collection of YouTube videos I have found useful in learning about hooks in Git. In no particular order:

Read More ›

Posts pagination

1 2 3 4 … 17

Recent Posts

  • A command line tool to compare 2 different csv files – sweetviz edition
  • Bots arrive on marquinsmith.com
  • Physical Health Tracker – October 2025
  • Jeff Booth conversation on Simply Bitcoin
  • A `.sqlfluff` settings file I like

Categories

  • Automation
  • Business
  • cybersecurity
  • Data Analysis
  • Finance
  • Personal Development
  • Python
  • Uncategorised
  • Web Analytics

Archives

Copyright © 2025 MarquinSmith.
Theme Easthill by ThemeMunk. Powered by WordPress.