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

Category: Data Analysis

Data Analysis

Loading data into Google Sheets Using python

20th July 201722nd July 2017 M SmithLeave a comment

This is a guide to programatically load a python pandas DataFrame (python 3) into a Google Sheets spreadsheet. Google Sheets is a useful tool to use in the daily tasks …

Read More ›
Data Analysis

Automating Google Analytics reports in Google Sheets

24th June 201724th June 2017 M SmithLeave a comment

This guide will walkthrough how to create automatically updating Google Analytics reports. This is for those who need to report on Google Analytics data regularly, and need to get access …

Read More ›

Posts pagination

1 … 4 5 6 7

Recent Posts

  • A command line tool to compare 2 different csv files – sweetviz edition
  • Bots arrive on marquinsmith.com
  • Physical Health Tracker – October 2025
  • Jeff Booth conversation on Simply Bitcoin
  • A `.sqlfluff` settings file I like

Categories

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

Archives

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