Category: Data Analysis

I’ve been trying to keep the cost of electricity down by turning on/ff the hot water cylinder, which I see as something I have control of and does use quite a bit of electricity. Your morning coffee, evening lights and cooking are things you do as a matter of course, and I’m not going to

I walk on Lyall bay beach and watch as new properties being built along the foreshore. I wonder how these will be managed with sea level rise. There has been work on the sand dunes and rocks added to try and reduce scouring at East End on beach last year. Lyall bay would be exposed

My Howya died recently, may it RIP, I had it for 3 years and definitely value for money. I upgraded to an Oppo phone, one of the criteria was that the new phone had NFC (Near field communication) so that I could play with tags. I’d bought, on Ali Express a NFC card read/writer that

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,

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

I suppose I could use PowerBI but I’ll srick with Excel for the moment. PowerBI has the dashboard but I did find it slow, its speed may have improved but that is for testing another day. I’m using the John Hopkins Github repository of Data which is updated daily and what they use for their

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

At the end of the fist part I’d got some data to play with from a couple of sources, cleaned it up, got some data to make paths to create a map and coloured map in by region based on covid cases. This was done using Excel, Notepad++ and displayed in browser. I was just

I’m thinking of trying to do an NZ map of regions where cases are. I’m using link to Wikipedia 2020 coronavirus pandemic in New Zealand page for data on region data. I have been looking for polylines for these regions and also centroids for region polylines. No luck so far with centroids but I got

I really enjoy the curated maps that Keir Clark presents on his Maps Mania website. I get them through my RSS feed and there are some pretty interesting ones. He had this article Sub Francisco about Andrei Kashcha’s City Roads rendering in brouser of a selected city roadways. After selecting your city of choice you