Data Analyst
Below is a table to show how Covid-19 is affecting various countries – those which have suffered >200 deaths in the last 7 days (as of 14th March 2021). Some countries were not included in this dataset from https://ourworldindata.org/coronavirus-source-data including major nations such as USA, and countries suffering at the moment such as Czechia. Looking…
Returning to Chess.com data (see here: http://www.neilmcniven.co.uk/3-conditional-formatting-of-bar-chart-colours-on-other-columns-of-data/), I had collected and saved all of my chess puzzle data from 29th Dec 2020 until 15th Jan 2021. Each day had its own CSV file looking like the one imaged below. Each row gives the date, puzzle rating, number of moves correctly made out of the target…
Continuing to look at Power BI, I decided to see how easy it is to import raw data from the internet in the form of web page tables, and get useful information visualised from it. I chose to use the BBC Weather website page for my location. Six tables were automagically found on the webpage,…
Chess.com offers puzzles to help people to improve their chess playing skills. The stats relating to the last 25 puzzles completed by any user of the website can be see online here: https://www.chess.com/stats/puzzles/PLAYERUSERNAME , as shown below. I copied a table of this data, dropped it into an Excel worksheet, and added an index column…
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…
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 is my running record from 1st Jan – 28th Feb 2021. Click on the table image below to see the details clearly. * For details on the WMA age-grade scores, see here: http://www.neilmcniven.co.uk/comparing-the-quality-of-timed-runs-of-different-distances/. Below are my record 7 day and 14 day total running distances from 2019-2021 inclusive.