Using the data we extracted from the wikipedia page in http://dbtuna.co.uk/using-beautifulsoup-to-extract-data-from-wikipedia/ we can quickly work out a whole bunch of stats about Premiership managers over the years.
Which Premiership Club has had the most managers?
df.groupby(["Club"]).size()
Arsenal 9 Aston Villa 19 Barnsley 1 Birmingham City 3 Blackburn Rovers 10 Blackpool 1 Bolton Wanderers 7 Bournemouth 1 Bradford City 4 Brighton & Hove Albion 2 Burnley 3 Cardiff City 4 Charlton Athletic 4 Chelsea 22 Coventry City 4 Crystal Palace 18 Derby County 6 Everton 16 Fulham 13 Huddersfield Town 3 Hull City 5 Ipswich Town 4 Leeds United 6 Leicester City 15 Liverpool 10 Manchester City 13 Manchester United 6 Middlesbrough 7 Newcastle United 23 Norwich City 8 Nottingham Forest 6 Oldham Athletic 1 Portsmouth 9 Queens Park Rangers 8 Reading 3 Sheffield United 3 Sheffield Wednesday 6 Southampton 20 Stoke City 4 Sunderland 14 Swansea City 10 Swindon Town 1 Tottenham Hotspur 22 Watford 9 West Bromwich Albion 16 West Ham United 15 Wigan Athletic 5 Wimbledon 3 Wolverhampton Wanderers 4
Newcastle has had the most managers with 23! Although many were caretaker managers, and some have had the job more than once e.g. John Carver, Nigel Pearson and Chris Hughton. The longest serving manager for Newcastle in the premiership was Bobby Robson (duration 1824 days), followed by Kevin Keegan (1799 days) and Alan Pardew (1484 days).
Which nationality has had the most Premiership managers?
df.groupby(["Country"]).size()
Argentina 4 Austria 1 Brazil 1 Chile 2 Croatia 2 Denmark 1 England 208 France 10 Germany 4 Israel 3 Italy 16 Jamaica 1 Netherlands 12 Northern Ireland 14 Norway 3 Portugal 11 Republic of Ireland 14 Scotland 58 Serbia 1 Spain 14 Sweden 3 Switzerland 1 United States 2 Uruguay 1 Wales 19
Despite many foreign managers, the home countries of England, Scotland, Wales and Northern Ireland account for the most Premiership managers.
Who is the longest serving current Premiership manager?
df.loc[df['Status'] == "present"].sort_values(by=['Duration'], ascending=False)
| Name | Status | Country | Club | From | Until | Duration | Years in League |
|---|---|---|---|---|---|---|---|
| Eddie Howe | present | England | Bournemouth | 12-Oct-12 | Present* | 2651 | 2015– |
| Sean Dyche | present | England | Burnley | 30-Oct-12 | Present* | 2633 | 2014–2015 2016– |
| Jürgen Klopp | present | Germany | Liverpool | 08-Oct-15 | Present* | 1560 | 2015– |
| Chris Wilder | present | England | Sheffield United | 12-May-16 | Present* | 1343 | 2019– |
| Pep Guardiola | present | Spain | Manchester City | 01-Jul-16 | Present* | 1293 | 2016– |
| Daniel Farke | present | Germany | Norwich City | 25-May-17 | Present* | 965 | 2019– |
| Nuno Espírito Santo | present | Portugal | Wolverhampton Wanderers | 31-May-17 | Present* | 959 | 2018– |
| Roy Hodgson | present | England | Crystal Palace | 12-Sep-17 | Present* | 855 | 2017– |
| Dean Smith | present | England | Aston Villa | 10-Oct-18 | Present* | 462 | 2019– |
| Ralph Hasenhüttl | present | Austria | Southampton | 06-Dec-18 | Present* | 405 | 2018– |
| Ole Gunnar Solskjær | present | Norway | Manchester United | 19 December 2018[N 5] | Present* | 392 | 2018– |
| Brendan Rodgers | present | Northern Ireland | Leicester City | 27-Feb-19 | Present* | 322 | 2019– |
| Graham Potter | present | England | Brighton & Hove Albion | 20-May-19 | Present* | 240 | 2019– |
| Frank Lampard | present | England | Chelsea | 04-Jul-19 | Present* | 195 | 2019– |
| Steve Bruce | present | England | Newcastle United | 17-Jul-19 | Present* | 182 | 2019– |
| José Mourinho | present | Portugal | Tottenham Hotspur | 20-Nov-19 | Present* | 56 | 2019– |
| Nigel Pearson | present | England | Watford | 08-Dec-19 | Present* | 38 | 2019– |
| Carlo Ancelotti | present | Italy | Everton | 22-Dec-19 | Present* | 24 | 2019– |
| Mikel Arteta | present | Spain | Arsenal | 22-Dec-19 | Present* | 24 | 2019– |
| David Moyes | present | Scotland | West Ham United | 29-Dec-19 | Present* | 17 | 2019– |
Who has managed the most premiership clubs?
df.groupby(["Name"])["Club"].nunique().sort_values(ascending=False)
Name Sam Allardyce 7 Mark Hughes 6 Harry Redknapp 5 Alan Pardew 5 Roy Hodgson 5 Steve Bruce 5 Graeme Souness 4 David Moyes 4 Neil Warnock 4 Ron Atkinson 4 Chris Hughton 4 José Mourinho 3 George Graham 3 Joe Royle 3 Brendan Rodgers 3 Rafael Benítez 3 Kenny Dalglish 3 Peter Reid 3 Claudio Ranieri 3 Paul Lambert 3 Paul Jewell 3 Dave Bassett 3 Nigel Pearson 3 Martin O'Neill 3 Avram Grant 3 Marco Silva 3 Glenn Hoddle 3 Iain Dowie 3 Tony Pulis 3 Steve Coppell 2 Kevin MacDonald 2 Steve Clarke 2 Claude Puel 2 Terry Venables 2 Tim Sherwood 2 Colin Todd 2 Danny Wilson 2 Kevin Keegan 2 Howard Wilkinson 2 Owen Coyle 2 Dave Jones 2 Ole Gunnar Solskjær 2 Nigel Adkins 2 Alan Curbishley 2 Alex McLeish 2 Alan Ball 2 Mike Walker 2 David O'Leary 2 David Pleat 2 Micky Adams 2 Mick McCarthy 2 Eric Black 2 Michael Appleton 2 Mauricio Pochettino 2 Graham Taylor 2 Martin Jol 2 Chris Hutchings 2 Ian Holloway 2 Brian Kidd 2 Brian Little 2 Steve McClaren 2 Gerry Francis 2 Joe Kinnear 2 Glenn Roeder 2 André Villas-Boas 2 John Deehan 2 Stuart Gray 2 Ruud Gullit 2 Gary Megson 2 John Gregory 2 Gordon Strachan 2 Ronald Koeman 2 Stuart Pearce 2 Roberto Martínez 2 Gérard Houllier 2 Roberto Di Matteo 2 Manuel Pellegrini 2 Bryan Robson 2 Ray Wilkins 2 Ray Lewington 2 Carlo Ancelotti 2
Sam Allardyce has managed the most teams in the Premier League, having taken charge of seven different clubs: Bolton Wanderers, Newcastle United, Blackburn Rovers, West Ham United, Sunderland, Crystal Palace and Everton.
0 Comments