This is a project I am undertaking as a way of understanding Jurgen Klopp's manager history since his first appointment. I am a Liverpool fan so this is something that I am Passionate about. Word has it that Jurgen Klopp's 7th Year is usually when his team starts to deteriorate. I will be looking to investigate this as well. It's also a way for me to practice my newly acquired data analysis skills. Although the data contains Jurgen's time at Mainz, Dortmund and Liverpool, I will mainly be focusing on his time at Liverpool. I will be using the data to answer the following questions:
- What is the best formation for Liverpool in the Premier League?
- What is the best starting 11 for Liverpool overall?
- What is the best starting 11 for Liverpool in the UEFA Super Cup?
- What is the best starting 11 for Liverpool in the UEFA Champions League?
- What is the best starting 11 for Liverpool in the UEFA Europa League?
- What is the best starting 11 for Liverpool in the FA Cup?
- What is the best starting 11 for Liverpool in the League Cup?
A few things to note:
- I will be using data scraped from transfermarkt.co.uk
- The data is not complete. I will be using the data that I have to answer the questions.
- The data I have is from when he started at Mainz in 2008 to his time in Liverpool on 10/10/2022.
- This is a work in progress. I will be updating this as I go along.
- Jurgen Klopp's trend in each of the teams he has managed
- Jurgen Klopp's trend in the Premier League
The data is in the data folder. The data is in the following format:
- jurgen_klopp_dataset.xlsx - This is the main dataset. It contains all the data I have scraped from transfermarkt.co.uk
- raw_dataset.txt - This is the raw dataset that I have scraped from transfermarkt.co.uk
- Date - The date of the match
- Competition - The competition the match was played in
- Season - The season the match was played in
- Home_team - The home team
- Away_team - The away team
- Home_score - The home team's score -- I might add this later
- Away_score - The away team's score -- I might add this later
- Tactics - The formation used by the team
- I will be cleaning the data as I go along. I will be adding more data as I go along.
According to the data, Liverpool have played a total of 391 matches under Jurgen Klopp. 176 of these matches were won by Liverpool, 82 were drawn and 133 were lost. 132 of these matches were won by Liverpool at home, and 22 matches were lost at home. 44 of these matches were won by Liverpool away from home, while a staggering 111 matches were lost. This depicts a very poor record for Liverpool away from home. Looking Further into the data we can Visualize how many matches Jurgen Klopp managed in each competition:
Bundesliga 340
Premier League 266
2. Bundesliga 148
UEFA Champions League 96
DFB-Pokal 44
FA Cup 21
Europa League 19
EFL Cup 18
League Cup 5
DFL-Supercup 4
UEFA-Cup (- 2009) 4
Community Shield 3
UEFA-Cup Qualifikation 3
UEFA Champions League Qualifying 2
FIFA Club World Cup 2
Europa League Qualifying 2
UEFA Super Cup 1
Of the 96 matches that Jurgen Klopp has managed in the UEFA Champions League, 60 of those matches were played by Liverpool. 37 of these matches were won, 14 were lost and 9 were drawn. 20 matches were won by Liverpool at home, and only 4 matches were lost at home. Away from home, Liverpool won 17 matches and lost 10 matches.
-- I will be adding this later
-- I will be adding this later
-- I will be adding this later
- The data is not complete. I will be using the data that I have to answer the questions.
- The data I have is from when he started at Mainz in 2008 to his time in Liverpool on 10/10/2022.
- The data does not automatically update. I will have to manually update the data as I go along. -- I will be adding this later
-
https://www.transfermarkt.co.uk/jurgen-klopp/profil/trainer/1129
Thank you for reading this far. I hope you enjoy the project.!!