Explore and Visualize a Dataset with PythonOr how to learn to create beautiful and insightful graphs…Extracting data from various sheets with PythonOr…
Continue Readingsheets
The ultimate guide to Google Sheets as a reliable data source
I can already feel your heart starting to race thinking about how many best practices this approach violates!Stay with me.…
Continue ReadingGoogle Sheets in R Shiny — a happy maRriage?
Why not just use an embedded Google Sheet in Rshiny. Here were our assumptions:Sheets are Google’s online spreadsheet solution, which…
Continue ReadingMake Your Own Twitter Bot With Google Sheets and Google Apps Script (GAS)
Yes, really. The reason is pretty simple. Google Sheets are super easy to use, and while there are a few…
Continue ReadingHow to use Google Sheets as a CMS or a database
????2. Set up the Google APIIn order to connect with your sheet, you need to use the Google API. Go to…
Continue ReadingMythbusting Fantasy Premier League: Form over fixtures
Therefore, to test whether form is indeed more important than fixture, I used FPL data since 2016 to compare their…
Continue ReadingPeriodically scraping websites, saving to Google Sheets, and firing Slack notifications
I hope this serves as a launch pad for users wanting to automate tedious tasks throughout their day to free…
Continue Reading