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: Python

Data Analysis

Simple logging to SQLite database from python

5th July 20245th July 2024 M SmithLeave a comment

A lightweight example of saving some logs to an SQLite database in a python script.

Read More ›
Python

Adding user login to Streamlit apps

5th July 20245th July 2024 M SmithLeave a comment

A short guide to adding user authentication to Streamlit apps. So you’ve created a beautiful Streamlit app which your users love, but only certain people should be able to access …

Read More ›
Python

Adding web analytics tracking to Streamlit apps

2nd January 20242nd January 2024 M SmithLeave a comment

Having gone through all the effort of creating a Streamlit application, you want to know if the people you have shared the application with are actually using it or not. …

Read More ›
Data Analysis

Getting started with Streamlit

1st September 20234th July 2024 M Smith1 Comment

Video Tutorials 30 days of Streamlit Build a different Streamlit app each day for 30 days https://blog.streamlit.io/30-days-of-streamlit/ Streamlit documentation Offical Streamlit documentation. Very user friendly and accessible reference materials. https://docs.streamlit.io/library/get-started …

Read More ›
Data Analysis

How to host a Streamlit app on Google Cloud Run

26th August 202316th September 2023 M SmithLeave a comment

A short guide for deploying a Streamlit app to Cloud Run on Google Cloud platform. Google Cloud Run is a managed platform for hosting and running docker containers. So once …

Read More ›
Data Analysis

Introduction to Google Colab

12th December 202012th December 2020 M SmithLeave a comment

Colab is a free Jupyter notebook environment that runs entirely in the cloud. Most importantly, it does not require a setup and the notebooks that you create can be simultaneously …

Read More ›
Python

Creating a Flask App on a subdomain

18th August 202018th August 2020 M Smith1 Comment

Background This website is hosted on Digital Ocean with WordPress. While WordPress is a great tool for building a website I wanted a place where I could build and host …

Read More ›
Data Analysis

A Basic Data Studio dashboard with Matomo Analytics data

18th April 202018th April 2020 M SmithLeave a comment

This post walks through how to create a Data Studio dashboard like the one below using Matomo analytics data. The components used to put this together include: A Matomo installation …

Read More ›
Data Analysis

Interacting with Big Query using pandas

15th March 202015th March 2020 M Smith1 Comment

Big Query For those who are into data, Big Query is a great choice if you would like a database but database management is not your thing. Big Query acts …

Read More ›
Python

Making HTML reports from markdown files

25th December 201925th December 2019 M SmithLeave a comment

Since having found Markdown a few years back I have become a big fan. Markdown is a language that allows you to write plain text that can be converted into …

Read More ›

Posts pagination

1 2 3

Recent Posts

  • Physical Health Tracker – March 2025
  • The missing README – recommended reading
  • Simple made Easy
  • Data analysts as Cartographers
  • Architecture Decision Record Template

Categories

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

Archives

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