The Apteco Datathon: 5. What is significant about East Anglian football?
Let’s move things up a notch and pull together a consolidated league table for the top four English divisions and place each of the teams from 1-92. By then adding season as a dimension we can then track the finishing positions of teams over multiple seasons.
I’ve altered the points calculations so that teams in higher divisions get much higher points so that the 20 teams in the top division will occupy positions 1-20, then the next cyprus mobile number division 21-44, 45-68 and then finally 69-92. A team that dropped out of the top four divisions in a given season would be represented by position 93 as they would have scored 0 points in that season. Note here that the season variable values refer to the start year of the season.
The Apteco Datathon: 5. What is significant about East Anglian football?
The above cube shows a subset of the league teams, but shows plenty of interesting teams:
Leicester City’s remarkable season in 2015 stands out.
There are generally improving teams like Huddersfield and Luton.
There are very successful teams like Manchester City and Manchester United.
There are generally weakening teams like Leyton Orient and Milton Keynes Dons.
There are very stable teams in lower leagues, like Ipswich City and Leeds United.
There are teams like Hull City that have yo-yoed between divisions.
An extension of the above analysis allows us to compare teams over time. Which teams have improved or maintained their finishing positions over the last few seasons? but both Plymouth and Preston North End have had six seasons. Can they keep that going this year.