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
    • Nutrition Course
    • Strength and fitness masterclass
    • Workout Stats
    • Physical Activity Stats
    • Crossfit Workouts
    • 6 week pre season soccer fitness plan
  • About

Category: Uncategorised

Uncategorised

Physical Health Tracker – April 2025

27th May 2025 M SmithLeave a comment
Read More ›
Uncategorised

Physical Health Tracker – November 2024

4th December 20244th December 2024 M SmithLeave a comment
Read More ›
Uncategorised

Physical Health Tracker – September 2024

6th October 20246th October 2024 M SmithLeave a comment
Read More ›
Uncategorised

Using SQL in pandas with duckdb

7th July 20247th July 2024 M SmithLeave a comment

A code snippet showing how to use SQL to query a pandas dataframe using duckdb. See this post by duckdb. SQL logic, functions and syntax fit my brain better than …

Read More ›
Uncategorised

Physical Health Tracker – October 2023

14th November 202312th November 2023 M SmithLeave a comment
Read More ›
Uncategorised

Export Google Sheets to pdf and send over Google chat

22nd October 202322nd October 2023 M SmithLeave a comment

Situation A beautiful report has been created in Google Sheets. The spreadsheet is exported to a pdf format and circulated with the relevant people via a Google Chat space. Complication …

Read More ›
Uncategorised

Load json data into SQLite using sqlite-utils

19th January 202318th January 2023 M SmithLeave a comment
Read More ›
Uncategorised

BigQuery table column names

18th January 202318th January 2023 M SmithLeave a comment
Read More ›
Uncategorised

Self reliance

10th April 202010th April 2020 M SmithLeave a comment
Read More ›
Uncategorised

Self Hosting Video on Digital Ocean

18th April 201911th May 2019 M SmithLeave a comment

Recently I have been playing around with Spaces on Digital Ocean. This is Digital Oceans version of object storage (think S3 for Amazon or Google Cloud Storage). Spaces comes with …

Read More ›

Recent Posts

  • Physical Health Tracker – April 2025
  • Generate date range in SQLite
  • Physical Health Tracker – March 2025
  • The missing README – recommended reading
  • Simple made Easy

Categories

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

Archives

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