We have used the football system in some of our earlier blogs as it has a rich set of transactions (“matches”) for each person (“team”). Many English club teams will have had over 4000 matches in over 130 seasons and have recorded over 100 different scorelines in that time.
In this section we will look at some new questions that we can now answer quickly using this Grouping Aggregation functionality.
Here are 4 interesting (well to me at least!) English football statistics questions:
What is the maximum number of croatia phone number example occurrences of the same scoreline in any English league football season for any team since WW2?
What is the maximum number of different scorelines in any English league football season for any team since WW2?
Has any team recorded a particular scoreline in every season since WW2? If so, what is the most number of times a scoreline has been recorded in every season?
When was the last time an English league football team recorded the same number of Wins, Draws and Losses in the same league season?
For the first 3 questions we need to analyse based upon 2 factors (scoreline and season), in the same manner as the example from the previous section. Since WW2 there have been 73 completed seasons (this blog written before the end of the 2019-20 season) and 83 different scorelines that have been recorded in English league football.
To answer the questions above we are effectively producing a 2D cross-tab for each individual team and then completing the analysis from there. Here is an example from one team. I have sorted the results based on the total overall scorelines for this team, so we can see how their most recent seasons have compared to their overall record.