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
Automation

String replacement across multiple files in current directory using `sed`

6th March 20264th March 2026 M SmithLeave a comment

The following bash code will replace any occurance of old text with some new text in all yaml files in the current directory when run on a mac. This is …

Read More ›
Personal Development

Physical Health Tracker – November 2025

5th March 20264th March 2026 M SmithLeave a comment
Read More ›
Finance

Bitcoin to Iranian Rial – God Candle

4th March 20264th March 2026 M SmithLeave a comment
Read More ›
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 ›

Posts pagination

1 2 3 4 … 17

Recent Posts

  • String replacement across multiple files in current directory using `sed`
  • Physical Health Tracker – November 2025
  • Bitcoin to Iranian Rial – God Candle
  • A command line tool to compare 2 different csv files – sweetviz edition
  • Bots arrive on marquinsmith.com

Categories

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

Archives

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