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

Tag: python

Python

Saving images to SQLite database

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

Execute queries in BigQuery in parallel using python

10th August 202410th August 2024 M SmithLeave a comment

An example of how to run multiple queries in parallel.

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

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

Environment Variables in Python

17th October 201917th October 2019 M SmithLeave a comment

Many python scripts require access to external services. API’s for example often require some credentials to be used in order to be able to access the services. These scripts need …

Read More ›
Python

Gotta catch ’em all

26th February 2018 M SmithLeave a comment

Recently I found myself needing to download images of all Pokemon for a personal project. And not wanting to download them all by hand I turned to python to help …

Read More ›

Some lesser known python libraries

8th October 20178th October 2017 M SmithLeave a comment

While listening to the Talk Python to me podcast I stumbled across this episode which talks in depth about “20 python libraries you aren’t using (but should)”.

Continue reading “Some lesser known python libraries” →

Read More ›

Posts pagination

1 2 3

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.