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
Data Analysis

An introduction to data testing – a presentation

1st April 20261st April 2026 M SmithLeave a comment

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 …

Read More ›
Personal Development

Physical Health Tracker – December 2025

30th March 202630th March 2026 M SmithLeave a comment
Read More ›
Data Analysis

Load an excel file into DuckDB database using Python

26th March 202626th March 2026 M SmithLeave a comment

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.

Read More ›
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 ›

Posts pagination

1 2 3 4 … 17

Recent Posts

  • An introduction to data testing – a presentation
  • Physical Health Tracker – December 2025
  • Load an excel file into DuckDB database using Python
  • String replacement across multiple files in current directory using `sed`
  • Physical Health Tracker – November 2025

Categories

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

Archives

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