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: 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 2 3 4 5

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.