Category: Data Extraction

Python AUTOMATE Email Forward Remove Attachment & Relocate Email

In a previous video , Python create Daily Planets Sky Map for Epheremis, Email & Automate –(https://www.youtube.com/watch?v=1LgB5kyCA08) I use python to attach created pdf document and attach to email and send to myself and others. Email sent to me with CSV attachment to Hotmail account In this video I’m sent a CSV file with meter

How to import JSON data into Google Sheets to create a live COVID-19 chart

This is in fact an article How to import JSON data into Google Sheets to create a live COVID-19 chart that I came across on my RSS feed from Datawrapper. I want to follow this as it sort of comes full circle. I’d started my covid data exploration with Google Sheets and importXML() and now,

Covid by region NZ -map representation- Part 5

The Ministry of Health(MoH) have posted the original dataset on a different web page of each case and which District Health Board (DHB) they are under. The data can be found here. Instead of by region, its mapped to the District Health Board Regions. So the original map I was using in this post is

Covid by region Globally -Data visualisation- Part 3

At the end of the last post I’d found that the original NZ regional dataset had changed. I was also finding it slow working in Google Sheets as the interwongle seems to be slow with so much demand. So I decided that I’d start working locally. My current process is to get the data, manipulate