Data Analyst
Pictured below is a chart showing my heart rate measured during (approximate) sleeping hours of midnight to 7am daily for the last seven months (October 2020 to April 2021 inclusive). There were around 96,000 heart rate measurements made by my sports watch, and only those taken between midnight and 7am were used below. Apparently my…
I have been collecting my heart rate data from my sports watch continuously since 15th October 2020. As of today (15th April 2021), I have 183 days of data or half a year with a total of 89,662 (non-exercising) heart rate readings. I am most interested in my sleeping heart rate and heart rate when…
Today I interpolated the 10km pace of all of my recorded runs of longer than 10km and those of my friend and plotted them on the chart below. (Click to view in full size.) Many of the runs were of far longer than 10km, so working out the average pace does not always allow for…
I have continued to experiment with Python to draw data charts, this time setting up Python (and Pandas, Numpy, SciPy, and Matplotlib) on Google Cloud Platform (https://cloud.google.com). Today (6th April 2021) I downloaded the latest official UK Coronavirus reported case data from https://coronavirus.data.gov.uk/details/cases and tried out some Matplotlib formatting and labelling.I made a column chart…
Below is a chart to show the WMA age grading (measure of quality) of my runs so far during 2021 up to and including today, 5th April 2021. Red markers are used to show the runs of 10km or above, and blue markers for the shorter runs. Each marker is labelled with the distance run,…
Today I took a look at the odds for the next couple of rounds of football matches in the Premier League after the international break. I imported the data directly into Excel from https://www.oddschecker.com/football/english/premier-league. I removed the columns of data I was not interested in using Power Query, and split the odds columns in two…
The international break is the perfect time to take a look at the state of the Premier League and the form of the teams with more than three-quarters of the 2020-2021 season completed. All match results and fixtures are available here: https://fixturedownload.com/download/xlsx/epl-2020, downloadable in Excel format. This file gives the round number, match date, match…
I got the Strava data for a couple of my friend’s long runs: a city half marathon from May 2019 and a 16 mile training run (for the London Marathon) from early-March 2020 before the marathon was cancelled. With Excel I tidied up the data and extracted the numerical data of interest. The chart below…
Getting back into running in 2020 after a slow start to the year and then the first Covid-19 lockdown resulted in some tactical walks being required during runs – particularly as the runs increased in length. The chart below, plotted in Excel, shows the distance and average speed of each of my runs of 2020.…
Today I quickly tried out a few different techniques with Excel to visualise my 2021 running data (up to and including 25th March) – mostly conditional formatting of charts and their data labels to try and show as much information as possible in single charts of different types. The first chart did not turn out…