In this blog post we’ll return back to the football dataset from an earlier blog post (1). In that post we undertook some analysis on international football matches. Our dataset has information on matches from a number of the European leagues, but in this post we’re going to look at some English league matches. We have data from matches since 1888 to the end of the 2017/18 season for the top four divisions of the English leagues.
In this blog, we’re going to take a look at some things that you’ll probably be able to find out quite easily, and hopefully some that aren’t so simple to find out! To give you the chance cyprus mobile number to test your footballing knowledge as you read the post, I’ll pose some questions as we go along – but don’t worry, the answers do follow!
League Tables
Let’s start off with for data accuracy. Can we replicate the 2017/18 Premier League table in a FastStats cube?
Well – here’s the result, a pretty close resemblance to the league table that you’d find from the 2017/18 season (2).
The Apteco Datathon: 5. What is significant about East Anglian football?
Now, let’s look at how we’ve created this cube. It has an underlying selection, one dimension and nine statistics (including one count statistic, three query statistics, two variable statistics, one expression statistic and two calculated statistics).
The data contains information on multiple leagues over many years, so our underlying selection will restrict the matches to just the English matches from the top division from last season. Adding team name as a dimension and a simple Count statistic gives us the 38 matches played by each team in a season (we’ve renamed the statistic to ‘Pld’ above).