Data Analyst
Having previously read in the BBC weather forecasts from the web using Power BI, today I attempted to read in and process the latest betting odds for the next 14 matches of Premier League football from https://www.oddschecker.com/football/english/premier-league. Initially it seemed like a very simple task, but then it turned out that the oddschecker.com sometimes changes…
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…
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…