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

Data Analysis

A personal health tracking tool

6th December 20246th December 2024 M SmithLeave a comment

For a little while now I have been using a personal health tracking tool to monitor my progress in various areas such as strength exercises, weight management and mental hygiene …

Read More ›
Uncategorised

Physical Health Tracker – November 2024

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

Retrieving an image (BLOB) from a SQLite database

27th November 202427th November 2024 M SmithLeave a comment
Read More ›
Python

Saving images to SQLite database

27th November 202427th November 2024 M SmithLeave a comment
Read More ›
Personal Development

Physical Health Tracker – October 2024

7th November 20247th November 2024 M SmithLeave a comment
Read More ›
Data Analysis

Load a broken csv file into duckdb

21st October 202421st October 2024 M SmithLeave a comment

Some CSV files have issues with them. Below is a code snippet to save the information in a csv file into a duckdb database, ignoring all the ‘broken’ rows.

Read More ›
Business

Requirements Gathering

15th October 202415th October 2024 M SmithLeave a comment

Requirements gathering is the process of understanding and documenting what characteristics a project must or should have. This is an important part of the project for success, after all if …

Read More ›
Data Analysis

Export BigQuery table to Google Cloud Storage

10th October 202415th October 2024 M SmithLeave a comment

A code example for how to write BigQuery SQL to export a table to Google Cloud Storage in csv and parquet file formats. Parquet CSV

Read More ›
Business

Data Ops Crash Course

8th October 202415th October 2024 M SmithLeave a comment

Data Ops, AKA Dev Ops for data. Essential content for learning about improving the velocity of development and effective maintenance of data products (products produced by data teams). Christopher Bergh …

Read More ›
Data Analysis

Pandas for data analysis – Video mega guide

7th October 20246th October 2024 M SmithLeave a comment

Pandas is the go to library in Python for analysing and manipulating data. This post lists some useful video resources for learning this package. Brandon Rhodes – Pandas From The …

Read More ›

Posts pagination

1 2 3 4 5 6 7 … 15

Recent Posts

  • How to revoke read access to a single table in BigQuery using SQL
  • How to grant read access to a single table in BigQuery using SQL
  • Copy a BigQuery model into another dataset using bq command line tool
  • A python command line tool to create dates in a range
  • Trigger an Airflow DAG in Google Cloud Composer using gcloud command line tool

Categories

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

Archives

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