Data Analyst
Lambda functions are now available in Excel (Office 365 only). You can now create your own user-defined functions without resorting to enabling macros and without using any VBA. Lambda functions are built instead from Excel formulas. I have some of my old running data files in which the times are given in decimal minutes –…
Looking at the data from Johns Hopkins (https://data.humdata.org/) to see how various countries are doing at the moment with regards to their respective fights against the Coronavirus pandemic. The chart below shows the percentage increase in deaths due to Covid-19 for last week compared to the reports from the week before for countries with >500…
Looking at the Covid-19 data for Brazil today (4th March 2021) – sourced from https://ourworldindata.org/coronavirus-source-data – daily reported cases are heading upwards exponentially. ….and daily deaths heading the same way.
Below is a CSV file containing data on the number of positive Covid-19 tests reported in the UK per day since the start of the pandemic (downloaded from https://coronavirus.data.gov.uk/) The chart below uses this data to show the number of reported Covid cases only on Tuesdays throughout the pandemic. This required a lot of learning…
From my fitness watch I have collected my heart pulse rate data from 15th October 2020 to 2nd March 2021 inclusive for a total of 43,318 readings. I have already processed this data many ways with Excel – for example, below, I look at my heart rate for the first 7 hours of the night…
I have used Python on and off ever since the Raspberry Pi was first released back in 2012 for renewable energy related projects: http://www.reuk.co.uk/wordpress/raspberry-pi/, but I always took any data output and processed it with PHP and/or visualised it with Excel. However, there are many modules which can be imported into Python which make it…
Here are the stats for my longest run of 2021 so far (and my sixth longest run ever): and here is the map of the route together with the elevation profile: