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

Getting started with Gemini CLI

29th May 202629th May 2026 M SmithLeave a comment

Various resources to jump start getting up and running with Gemini CLI. Gemini CLI is an AI agent that lives in the terminal. This has the benefit of being able …

Read More ›
Personal Development

Physical Health Tracker – 2025 in review

8th May 20268th May 2026 M SmithLeave a comment

Strength Sessions In 2025 I managed 98 strength workouts over the year. Which averages out to just under 2 sessions each week which is pretty good consistency. June and July …

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

Posts pagination

1 2 3 4 … 18

Recent Posts

  • Getting started with Gemini CLI
  • Physical Health Tracker – 2025 in review
  • An introduction to data testing – a presentation
  • Physical Health Tracker – December 2025
  • Load an excel file into DuckDB database using Python

Categories

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

Archives

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