Data Analyst
Today I used Excel to compare my current training for a half marathon in early September 2021 with the training of my friend who is training for the London Marathon in late April 2022. I looked only at runs of over 5km so far (8th April) in 2021 with my data coming from my own…
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,…
During the month of March 2021, I ran 11 times for a total distance of 123.54km with an average run distance of 11.23 km. The longest run was 15.19 km. No walk breaks were taken all month. The chart below shows that as of today (April 1st), I have run 341.56 km during 2021, and…
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…
I took a look at the latest Covid-19 daily deaths in English hospitals statistics, available to download from the NHS website here: https://www.england.nhs.uk/statistics/statistical-work-areas/covid-19-daily-deaths/. They include a weekly breakdown by age of those who have lost their lives after testing positive for coronavirus. The Excel chart above shows the number in each age-group who died with…
Looking at some more Concept 2 rowing machine workout data – this time from a sprint/interval session (20 seconds @ 90% of max effort, 1 minute rest, repeat 20 times.)The Concept 2 Performance Monitor only records a line record of data when a stroke is pulled, therefore it does not record anything during the 1…
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.…