Skip to content

Instantly share code, notes, and snippets.

@ikashnitsky

ikashnitsky/euro-2020-challenge.R

Last active June 23, 2021 06:49
Show Gist options
  • Save ikashnitsky/5f305b91aacd5ea61dbd64a2f938773d to your computer and use it in GitHub Desktop.
Save ikashnitsky/5f305b91aacd5ea61dbd64a2f938773d to your computer and use it in GitHub Desktop.
Download ZIP
Rostock Retreat Viz Uncertainty -- a small challenge
Raw
euro-2020-challenge.R
#===============================================================================
# 2021-06-23 -- Rosrock Retreat
# Dataviz challenge -- EURO 2020 data
# Ilya Kashnitsky, [email protected]
#===============================================================================
# Dataset is a detailed team squads data from Transfermarkt
# https://www.transfermarkt.com/euro-2020/teilnehmer/pokalwettbewerb/EM20
# For each country it looks like this
# https://www.transfermarkt.com/england/startseite/verein/3299
library(tidyverse)
library(magrittr)
# load the dataset
source("https://gist.githubusercontent.com/ikashnitsky/5f305b91aacd5ea61dbd64a2f938773d/raw/a3eb3d280946023cd66601de100482a36b144d6c/euro_2020_players.R")
# check the dataset
euro_2020_players %>% print()
# # consider
# euro_2020_players %>% xray::distributions()
# Have fun!
# Link to submit your output
# https://docs.google.com/forms/d/e/1FAIpQLSf2IPZ4-A4ZuT6_JkIrE1-Cs3-fzsHr_rGdwvUqevF47_dIMw/viewform
Raw
euro_2020_players.R
#===============================================================================
# 2021-06-23 -- Rosrock Retreat
# Dataviz challenge -- ready data
# Ilya Kashnitsky, [email protected]
#===============================================================================
euro_2020_players <- tibble::tribble(
~country, ~no, ~position, ~name, ~age, ~market_value, ~cntr, ~avg_age, ~avg_age_mv,
"england", "1", "Goalkeeper", "Jordan Pickford", 27L, 22, "England", 24.8461538461538, 23.9517022961203,
"england", "13", "Goalkeeper", "Aaron Ramsdale", 23L, 12, "England", 24.8461538461538, 23.9517022961203,
"england", "23", "Goalkeeper", "Sam Johnstone", 28L, 8, "England", 24.8461538461538, 23.9517022961203,
"england", "6", "Centre-Back", "Harry Maguire", 28L, 45, "England", 24.8461538461538, 23.9517022961203,
"england", "5", "Centre-Back", "John Stones", 27L, 30, "England", 24.8461538461538, 23.9517022961203,
"england", "15", "Centre-Back", "Tyrone Mings", 28L, 30, "England", 24.8461538461538, 23.9517022961203,
"england", "22", "Centre-Back", "Ben White", 23L, 28, "England", 24.8461538461538, 23.9517022961203,
"england", "16", "Centre-Back", "Conor Coady", 28L, 25, "England", 24.8461538461538, 23.9517022961203,
"england", "21", "Left-Back", "Ben Chilwell", 24L, 45, "England", 24.8461538461538, 23.9517022961203,
"england", "3", "Left-Back", "Luke Shaw", 25L, 35, "England", 24.8461538461538, 23.9517022961203,
"england", "24", "Right-Back", "Reece James", 21L, 40, "England", 24.8461538461538, 23.9517022961203,
"england", "2", "Right-Back", "Kyle Walker", 31L, 28, "England", 24.8461538461538, 23.9517022961203,
"england", "12", "Right-Back", "Kieran Trippier", 30L, 20, "England", 24.8461538461538, 23.9517022961203,
"england", "4", "Defensive Midfield", "Declan Rice", 22L, 65, "England", 24.8461538461538, 23.9517022961203,
"england", "14", "Defensive Midfield", "Kalvin Phillips", 25L, 30, "England", 24.8461538461538, 23.9517022961203,
"england", "26", "Central Midfield", "Jude Bellingham", 17L, 55, "England", 24.8461538461538, 23.9517022961203,
"england", "8", "Central Midfield", "Jordan Henderson", 31L, 20, "England", 24.8461538461538, 23.9517022961203,
"england", "25", "Left Midfield", "Bukayo Saka", 19L, 65, "England", 24.8461538461538, 23.9517022961203,
"england", "19", "Attacking Midfield", "Mason Mount", 22L, 75, "England", 24.8461538461538, 23.9517022961203,
"england", "10", "Left Winger", "Raheem Sterling", 26L, 90, "England", 24.8461538461538, 23.9517022961203,
"england", "11", "Left Winger", "Marcus Rashford", 23L, 85, "England", 24.8461538461538, 23.9517022961203,
"england", "20", "Left Winger", "Phil Foden", 21L, 80, "England", 24.8461538461538, 23.9517022961203,
"england", "7", "Left Winger", "Jack Grealish", 25L, 65, "England", 24.8461538461538, 23.9517022961203,
"england", "17", "Right Winger", "Jadon Sancho", 21L, 100, "England", 24.8461538461538, 23.9517022961203,
"england", "9", "Centre-Forward", "Harry Kane", 27L, 120, "England", 24.8461538461538, 23.9517022961203,
"england", "18", "Centre-Forward", "Dominic Calvert-Lewin", 24L, 45, "England", 24.8461538461538, 23.9517022961203,
"frankreich", "23", "Goalkeeper", "Mike Maignan", 25L, 25, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "1", "Goalkeeper", "Hugo Lloris", 34L, 9, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "16", "Goalkeeper", "Steve Mandanda", 36L, 2, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "4", "Centre-Back", "Raphaël Varane", 28L, 70, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "25", "Centre-Back", "Jules Koundé", 22L, 60, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "3", "Centre-Back", "Presnel Kimpembe", 25L, 40, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "15", "Centre-Back", "Kurt Zouma", 26L, 32, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "5", "Centre-Back", "Clément Lenglet", 26L, 25, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "21", "Left-Back", "Lucas Hernández", 25L, 45, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "18", "Left-Back", "Lucas Digne", 27L, 35, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "2", "Right-Back", "Benjamin Pavard", 25L, 35, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "24", "Right-Back", "Léo Dubois", 26L, 16, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "13", "Defensive Midfield", "N'Golo Kanté", 30L, 55, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "6", "Central Midfield", "Paul Pogba", 28L, 60, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "14", "Central Midfield", "Adrien Rabiot", 26L, 30, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "12", "Central Midfield", "Corentin Tolisso", 26L, 20, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "17", "Central Midfield", "Moussa Sissoko", 31L, 10, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "8", "Attacking Midfield", "Thomas Lemar", 25L, 25, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "20", "Left Winger", "Kingsley Coman", 25L, 65, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "26", "Left Winger", "Marcus Thuram", 23L, 35, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "11", "Right Winger", "Ousmane Dembélé", 24L, 50, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "7", "Second Striker", "Antoine Griezmann", 30L, 60, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "10", "Centre-Forward", "Kylian Mbappé", 22L, 160, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "22", "Centre-Forward", "Wissam Ben Yedder", 30L, 35, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "19", "Centre-Forward", "Karim Benzema", 33L, 25, "France", 27.3846153846154, 25.9260700389105,
"frankreich", "9", "Centre-Forward", "Olivier Giroud", 34L, 4, "France", 27.3846153846154, 25.9260700389105,
"deutschland", "12", "Goalkeeper", "Bernd Leno", 29L, 22, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "1", "Goalkeeper", "Manuel Neuer", 35L, 18, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "22", "Goalkeeper", "Kevin Trapp", 30L, 6, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "15", "Centre-Back", "Niklas Süle", 25L, 35, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "4", "Centre-Back", "Matthias Ginter", 27L, 30, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "2", "Centre-Back", "Antonio Rüdiger", 28L, 28, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "24", "Centre-Back", "Robin Koch", 24L, 17, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "5", "Centre-Back", "Mats Hummels", 32L, 12, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "20", "Left-Back", "Robin Gosens", 26L, 35, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "3", "Left-Back", "Marcel Halstenberg", 29L, 14, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "26", "Left-Back", "Christian Günter", 28L, 12, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "16", "Right-Back", "Lukas Klostermann", 25L, 27, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "6", "Defensive Midfield", "Joshua Kimmich", 26L, 90, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "23", "Defensive Midfield", "Emre Can", 27L, 26, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "18", "Central Midfield", "Leon Goretzka", 26L, 70, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "8", "Central Midfield", "Toni Kroos", 31L, 40, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "21", "Central Midfield", "Ilkay Gündogan", 30L, 40, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "17", "Central Midfield", "Florian Neuhaus", 24L, 35, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "7", "Attacking Midfield", "Kai Havertz", 22L, 70, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "14", "Attacking Midfield", "Jamal Musiala", 18L, 38, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "10", "Right Winger", "Serge Gnabry", 25L, 70, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "19", "Right Winger", "Leroy Sané", 25L, 60, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "13", "Right Winger", "Jonas Hofmann", 28L, 16, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "25", "Second Striker", "Thomas Müller", 31L, 30, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "11", "Centre-Forward", "Timo Werner", 25L, 65, "Germany", 27.0769230769231, 26.1698717948718,
"deutschland", "9", "Centre-Forward", "Kevin Volland", 28L, 30, "Germany", 27.0769230769231, 26.1698717948718,
"spanien", "23", "Goalkeeper", "Unai Simón", 24L, 20, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "1", "Goalkeeper", "David de Gea", 30L, 18, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "13", "Goalkeeper", "Robert Sánchez", 23L, 8, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "4", "Centre-Back", "Pau Torres", 24L, 50, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "24", "Centre-Back", "Aymeric Laporte", 27L, 45, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "3", "Centre-Back", "Diego Llorente", 27L, 20, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "12", "Centre-Back", "Eric García", 20L, 20, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "14", "Left-Back", "José Gayà", 26L, 35, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "18", "Left-Back", "Jordi Alba", 32L, 20, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "2", "Right-Back", "César Azpilicueta", 31L, 13, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "16", "Defensive Midfield", "Rodri", 25L, 70, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "5", "Defensive Midfield", "Sergio Busquets", 32L, 9, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "8", "Central Midfield", "Koke", 29L, 60, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "17", "Central Midfield", "Fabián Ruiz", 25L, 45, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "10", "Central Midfield", "Thiago", 30L, 30, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "6", "Attacking Midfield", "Marcos Llorente", 26L, 80, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "26", "Attacking Midfield", "Pedri", 18L, 70, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "19", "Attacking Midfield", "Dani Olmo", 23L, 45, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "21", "Left Winger", "Mikel Oyarzabal", 24L, 70, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "11", "Right Winger", "Ferran Torres", 21L, 50, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "20", "Right Winger", "Adama Traoré", 25L, 30, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "22", "Right Winger", "Pablo Sarabia", 29L, 22, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "7", "Centre-Forward", "Álvaro Morata", 28L, 45, "Spain", 26.1666666666667, 25.3857923497268,
"spanien", "9", "Centre-Forward", "Gerard Moreno", 29L, 40, "Spain", 26.1666666666667, 25.3857923497268,
"portugal", "12", "Goalkeeper", "Anthony Lopes", 30L, 14, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "22", "Goalkeeper", "Rui Silva", 27L, 12, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "1", "Goalkeeper", "Rui Patrício", 33L, 10, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "4", "Centre-Back", "Rúben Dias", 24L, 75, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "6", "Centre-Back", "José Fonte", 37L, 1, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "3", "Centre-Back", "Pepe", 38L, 1, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "5", "Left-Back", "Raphaël Guerreiro", 27L, 40, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "25", "Left-Back", "Nuno Mendes", 19L, 40, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "2", "Right-Back", "Nélson Semedo", 27L, 28, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "20", "Right-Back", "Diogo Dalot", 22L, 10, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "18", "Defensive Midfield", "Rúben Neves", 24L, 45, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "13", "Defensive Midfield", "Danilo Pereira", 29L, 20, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "26", "Defensive Midfield", "João Palhinha", 25L, 18, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "14", "Defensive Midfield", "William Carvalho", 29L, 15, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "16", "Central Midfield", "Renato Sanches", 23L, 30, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "24", "Central Midfield", "Sérgio Oliveira", 29L, 19, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "8", "Central Midfield", "João Moutinho", 34L, 4, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "15", "Right Midfield", "Rafa Silva", 28L, 23, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "11", "Attacking Midfield", "Bruno Fernandes", 26L, 90, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "10", "Attacking Midfield", "Bernardo Silva", 26L, 70, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "19", "Attacking Midfield", "Pedro Gonçalves", 22L, 22, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "21", "Left Winger", "Diogo Jota", 24L, 45, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "17", "Left Winger", "Gonçalo Guedes", 24L, 25, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "23", "Second Striker", "João Félix", 21L, 80, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "7", "Centre-Forward", "Cristiano Ronaldo", 36L, 45, "Portugal", 27.2692307692308, 25.4897218863362,
"portugal", "9", "Centre-Forward", "André Silva", 25L, 45, "Portugal", 27.2692307692308, 25.4897218863362,
"italien", "21", "Goalkeeper", "Gianluigi Donnarumma", 22L, 60, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "26", "Goalkeeper", "Alex Meret", 24L, 20, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "1", "Goalkeeper", "Salvatore Sirigu", 34L, 2, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "23", "Centre-Back", "Alessandro Bastoni", 22L, 60, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "25", "Centre-Back", "Rafael Tolói", 30L, 15, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "15", "Centre-Back", "Francesco Acerbi", 33L, 10, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "19", "Centre-Back", "Leonardo Bonucci", 34L, 8, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "3", "Centre-Back", "Giorgio Chiellini", 36L, 1, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "4", "Left-Back", "Leonardo Spinazzola", 28L, 26, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "13", "Left-Back", "Emerson", 26L, 12, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "2", "Right-Back", "Giovanni Di Lorenzo", 27L, 24, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "24", "Right-Back", "Alessandro Florenzi", 30L, 13, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "8", "Defensive Midfield", "Jorginho", 29L, 40, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "5", "Defensive Midfield", "Manuel Locatelli", 23L, 35, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "18", "Central Midfield", "Nicolò Barella", 24L, 65, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "6", "Central Midfield", "Marco Verratti", 28L, 55, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "7", "Central Midfield", "Gaetano Castrovilli", 24L, 20, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "16", "Central Midfield", "Bryan Cristante", 26L, 18, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "12", "Attacking Midfield", "Matteo Pessina", 24L, 20, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "10", "Left Winger", "Lorenzo Insigne", 30L, 48, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "14", "Right Winger", "Federico Chiesa", 23L, 60, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "11", "Right Winger", "Domenico Berardi", 26L, 35, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "20", "Right Winger", "Federico Bernardeschi", 27L, 15, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "17", "Centre-Forward", "Ciro Immobile", 31L, 38, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "9", "Centre-Forward", "Andrea Belotti", 27L, 35, "Italy", 27.2692307692308, 25.8933333333333,
"italien", "22", "Centre-Forward", "Giacomo Raspadori", 21L, 15, "Italy", 27.2692307692308, 25.8933333333333,
"belgien", "1", "Goalkeeper", "Thibaut Courtois", 29L, 60, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "12", "Goalkeeper", "Simon Mignolet", 33L, 8, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "13", "Goalkeeper", "Matz Sels", 29L, 6, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "18", "Centre-Back", "Jason Denayer", 25L, 25, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "2", "Centre-Back", "Toby Alderweireld", 32L, 11, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "4", "Centre-Back", "Dedryck Boyata", 30L, 8, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "5", "Centre-Back", "Jan Vertonghen", 34L, 6, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "3", "Centre-Back", "Thomas Vermaelen", 35L, 0.9, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "21", "Right-Back", "Timothy Castagne", 25L, 28, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "15", "Right-Back", "Thomas Meunier", 29L, 12, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "19", "Defensive Midfield", "Leander Dendoncker", 26L, 30, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "6", "Defensive Midfield", "Axel Witsel", 32L, 9, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "8", "Central Midfield", "Youri Tielemans", 24L, 55, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "26", "Central Midfield", "Dennis Praet", 27L, 18, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "7", "Attacking Midfield", "Kevin De Bruyne", 29L, 100, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "17", "Attacking Midfield", "Hans Vanaken", 28L, 13, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "10", "Left Winger", "Eden Hazard", 30L, 40, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "11", "Left Winger", "Yannick Carrasco", 27L, 40, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "16", "Left Winger", "Thorgan Hazard", 28L, 27, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "24", "Left Winger", "Leandro Trossard", 26L, 17, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "22", "Left Winger", "Nacer Chadli", 31L, 5, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "25", "Right Winger", "Jérémy Doku", 19L, 22, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "9", "Centre-Forward", "Romelu Lukaku", 28L, 100, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "23", "Centre-Forward", "Michy Batshuayi", 27L, 10, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "14", "Centre-Forward", "Dries Mertens", 34L, 9, "Belgium", 28.7307692307692, 27.6775302735835,
"belgien", "20", "Centre-Forward", "Christian Benteke", 30L, 9, "Belgium", 28.7307692307692, 27.6775302735835,
"niederlande", "23", "Goalkeeper", "Marco Bizot", 30L, 5, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "13", "Goalkeeper", "Tim Krul", 33L, 2, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "1", "Goalkeeper", "Maarten Stekelenburg", 38L, 0.55, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "3", "Centre-Back", "Matthijs de Ligt", 21L, 75, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "6", "Centre-Back", "Stefan de Vrij", 29L, 50, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "4", "Centre-Back", "Nathan Aké", 26L, 32, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "17", "Centre-Back", "Daley Blind", 31L, 15, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "25", "Centre-Back", "Jurrien Timber", 20L, 11, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "5", "Left-Back", "Owen Wijndal", 21L, 17, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "12", "Left-Back", "Patrick van Aanholt", 30L, 7, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "22", "Right-Back", "Denzel Dumfries", 25L, 16, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "2", "Right-Back", "Joël Veltman", 29L, 6, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "15", "Defensive Midfield", "Marten de Roon", 30L, 23, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "24", "Defensive Midfield", "Teun Koopmeiners", 23L, 16, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "21", "Central Midfield", "Frenkie de Jong", 24L, 90, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "16", "Central Midfield", "Ryan Gravenberch", 19L, 33, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "8", "Central Midfield", "Georginio Wijnaldum", 30L, 30, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "14", "Attacking Midfield", "Davy Klaassen", 28L, 17, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "26", "Left Winger", "Cody Gakpo", 22L, 18, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "11", "Left Winger", "Quincy Promes", 29L, 15, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "7", "Right Winger", "Steven Berghuis", 29L, 12, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "10", "Centre-Forward", "Memphis Depay", 27L, 45, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "18", "Centre-Forward", "Donyell Malen", 22L, 30, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "19", "Centre-Forward", "Wout Weghorst", 28L, 30, "Netherlands", 26.96, 25.3239204029395,
"niederlande", "9", "Centre-Forward", "Luuk de Jong", 30L, 10, "Netherlands", 26.96, 25.3239204029395,
"kroatien", "1", "Goalkeeper", "Dominik Livakovic", 26L, 15, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "12", "Goalkeeper", "Lovre Kalinic", 31L, 2, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "23", "Goalkeeper", "Simon Sluga", 28L, 1, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "5", "Centre-Back", "Duje Caleta-Car", 24L, 25, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "25", "Centre-Back", "Josko Gvardiol", 19L, 19, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "6", "Centre-Back", "Dejan Lovren", 31L, 10, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "21", "Centre-Back", "Domagoj Vida", 32L, 4, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "16", "Centre-Back", "Mile Skoric", 30L, 1, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "3", "Left-Back", "Borna Barisic", 28L, 6, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "24", "Left-Back", "Domagoj Bradaric", 21L, 6, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "2", "Right-Back", "Sime Vrsaljko", 29L, 5, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "22", "Right-Back", "Josip Juranovic", 25L, 2, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "11", "Defensive Midfield", "Marcelo Brozovic", 28L, 40, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "19", "Defensive Midfield", "Milan Badelj", 32L, 2, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "8", "Central Midfield", "Mateo Kovacic", 27L, 45, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "15", "Central Midfield", "Mario Pasalic", 26L, 23, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "10", "Central Midfield", "Luka Modric", 35L, 10, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "4", "Left Midfield", "Ivan Perisic", 32L, 10, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "13", "Attacking Midfield", "Nikola Vlasic", 23L, 30, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "26", "Attacking Midfield", "Luka Ivanusec", 22L, 13, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "17", "Left Winger", "Ante Rebic", 27L, 32, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "7", "Left Winger", "Josip Brekalo", 23L, 12, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "18", "Left Winger", "Mislav Orsic", 28L, 12, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "9", "Centre-Forward", "Andrej Kramaric", 30L, 28, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "20", "Centre-Forward", "Bruno Petkovic", 26L, 12, "Croatia", 27.3846153846154, 26.5508021390374,
"kroatien", "14", "Centre-Forward", "Ante Budimir", 29L, 9, "Croatia", 27.3846153846154, 26.5508021390374,
"turkei", "23", "Goalkeeper", "Ugurcan Cakir", 25L, 19, "Turkey", 24.5769230769231, 24.1625,
"turkei", "12", "Goalkeeper", "Altay Bayindir", 23L, 14, "Turkey", 24.5769230769231, 24.1625,
"turkei", "1", "Goalkeeper", "Mert Günok", 32L, 2, "Turkey", 24.5769230769231, 24.1625,
"turkei", "4", "Centre-Back", "Caglar Söyüncü", 25L, 45, "Turkey", 24.5769230769231, 24.1625,
"turkei", "3", "Centre-Back", "Merih Demiral", 23L, 28, "Turkey", 24.5769230769231, 24.1625,
"turkei", "15", "Centre-Back", "Ozan Kabak", 21L, 25, "Turkey", 24.5769230769231, 24.1625,
"turkei", "22", "Centre-Back", "Kaan Ayhan", 26L, 6, "Turkey", 24.5769230769231, 24.1625,
"turkei", "13", "Left-Back", "Umut Meras", 25L, 2, "Turkey", 24.5769230769231, 24.1625,
"turkei", "18", "Left-Back", "Ridvan Yilmaz", 20L, 2, "Turkey", 24.5769230769231, 24.1625,
"turkei", "2", "Right-Back", "Zeki Celik", 24L, 20, "Turkey", 24.5769230769231, 24.1625,
"turkei", "25", "Right-Back", "Mert Müldür", 22L, 9, "Turkey", 24.5769230769231, 24.1625,
"turkei", "5", "Defensive Midfield", "Okay Yokuslu", 27L, 7, "Turkey", 24.5769230769231, 24.1625,
"turkei", "14", "Defensive Midfield", "Taylan Antalyali", 26L, 6, "Turkey", 24.5769230769231, 24.1625,
"turkei", "19", "Central Midfield", "Orkun Kökcü", 20L, 12, "Turkey", 24.5769230769231, 24.1625,
"turkei", "6", "Central Midfield", "Ozan Tufan", 26L, 11, "Turkey", 24.5769230769231, 24.1625,
"turkei", "21", "Central Midfield", "Irfan Can Kahveci", 25L, 11, "Turkey", 24.5769230769231, 24.1625,
"turkei", "8", "Central Midfield", "Dorukhan Toköz", 25L, 4, "Turkey", 24.5769230769231, 24.1625,
"turkei", "10", "Attacking Midfield", "Hakan Calhanoglu", 27L, 35, "Turkey", 24.5769230769231, 24.1625,
"turkei", "20", "Attacking Midfield", "Abdülkadir Ömür", 21L, 8, "Turkey", 24.5769230769231, 24.1625,
"turkei", "24", "Left Winger", "Kerem Aktürkoglu", 22L, 3, "Turkey", 24.5769230769231, 24.1625,
"turkei", "7", "Right Winger", "Cengiz Ünder", 23L, 18, "Turkey", 24.5769230769231, 24.1625,
"turkei", "11", "Second Striker", "Yusuf Yazici", 24L, 20, "Turkey", 24.5769230769231, 24.1625,
"turkei", "16", "Centre-Forward", "Enes Ünal", 24L, 7, "Turkey", 24.5769230769231, 24.1625,
"turkei", "26", "Centre-Forward", "Halil Dervisoglu", 21L, 2, "Turkey", 24.5769230769231, 24.1625,
"turkei", "17", "Centre-Forward", "Burak Yilmaz", 35L, 2, "Turkey", 24.5769230769231, 24.1625,
"turkei", "9", "Centre-Forward", "Kenan Karaman", 27L, 2, "Turkey", 24.5769230769231, 24.1625,
"osterreich", "1", "Goalkeeper", "Alexander Schlager", 25L, 3, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "13", "Goalkeeper", "Daniel Bachmann", 26L, 0.8, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "12", "Goalkeeper", "Pavao Pervan", 33L, 0.6, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "8", "Centre-Back", "David Alaba", 28L, 55, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "4", "Centre-Back", "Martin Hinteregger", 28L, 18, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "15", "Centre-Back", "Philipp Lienhart", 24L, 14, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "5", "Centre-Back", "Stefan Posch", 24L, 13, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "26", "Centre-Back", "Marco Friedl", 23L, 7, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "3", "Centre-Back", "Aleksandar Dragovic", 30L, 3, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "2", "Left-Back", "Andreas Ulmer", 35L, 0.8, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "21", "Right-Back", "Stefan Lainer", 28L, 12, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "16", "Right-Back", "Christopher Trimmel", 34L, 1, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "10", "Defensive Midfield", "Florian Grillitsch", 25L, 18, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "6", "Defensive Midfield", "Stefan Ilsanker", 32L, 1, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "14", "Defensive Midfield", "Julian Baumgartlinger", 33L, 1, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "9", "Central Midfield", "Marcel Sabitzer", 27L, 42, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "23", "Central Midfield", "Xaver Schlager", 23L, 27, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "24", "Central Midfield", "Konrad Laimer", 24L, 26, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "22", "Right Midfield", "Valentino Lazaro", 25L, 10, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "18", "Right Midfield", "Alessandro Schöpf", 27L, 1, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "19", "Attacking Midfield", "Christoph Baumgartner", 21L, 22, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "17", "Attacking Midfield", "Louis Schaub", 26L, 2, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "11", "Second Striker", "Michael Gregoritsch", 27L, 3, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "25", "Centre-Forward", "Sasa Kalajdzic", 23L, 22, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "7", "Centre-Forward", "Marko Arnautovic", 32L, 10, "Austria", 27.3846153846154, 25.7292852624921,
"osterreich", "20", "Centre-Forward", "Karim Onisiwo", 29L, 3, "Austria", 27.3846153846154, 25.7292852624921,
"danemark", "1", "Goalkeeper", "Kasper Schmeichel", 34L, 6, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "22", "Goalkeeper", "Frederik Rönnow", 28L, 2, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "16", "Goalkeeper", "Jonas Lössl", 32L, 1, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "6", "Centre-Back", "Andreas Christensen", 25L, 30, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "2", "Centre-Back", "Joachim Andersen", 25L, 22, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "3", "Centre-Back", "Jannik Vestergaard", 28L, 18, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "4", "Centre-Back", "Simon Kjaer", 32L, 10, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "13", "Centre-Back", "Zanka", 31L, 1, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "26", "Left-Back", "Nicolai Boilesen", 29L, 0.7, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "5", "Right-Back", "Joakim Maehle", 24L, 13, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "18", "Right-Back", "Daniel Wass", 32L, 7, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "17", "Right-Back", "Jens Stryger Larsen", 30L, 4, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "8", "Defensive Midfield", "Thomas Delaney", 29L, 15, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "23", "Central Midfield", "Pierre-Emile Höjbjerg", 25L, 35, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "24", "Central Midfield", "Mathias Jensen", 25L, 8, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "15", "Central Midfield", "Christian Nörgaard", 27L, 3, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "25", "Central Midfield", "Anders Christiansen", 31L, 2, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "10", "Attacking Midfield", "Christian Eriksen", 29L, 40, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "14", "Left Winger", "Mikkel Damsgaard", 20L, 13, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "7", "Right Winger", "Robert Skov", 25L, 10, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "11", "Right Winger", "Andreas Skov Olsen", 21L, 6, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "20", "Centre-Forward", "Yussuf Poulsen", 27L, 21, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "12", "Centre-Forward", "Kasper Dolberg", 23L, 20, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "9", "Centre-Forward", "Martin Braithwaite", 30L, 9, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "21", "Centre-Forward", "Andreas Cornelius", 28L, 6, "Denmark", 27.3846153846154, 26.4780630484238,
"danemark", "19", "Centre-Forward", "Jonas Wind", 22L, 5, "Denmark", 27.3846153846154, 26.4780630484238,
"schweiz", "21", "Goalkeeper", "Gregor Kobel", 23L, 13, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "1", "Goalkeeper", "Yann Sommer", 32L, 6, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "12", "Goalkeeper", "Yvon Mvogo", 27L, 4, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "5", "Centre-Back", "Manuel Akanji", 25L, 30, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "4", "Centre-Back", "Nico Elvedi", 24L, 28, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "22", "Centre-Back", "Fabian Schär", 29L, 9, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "24", "Centre-Back", "Becir Omeragic", 19L, 5, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "25", "Centre-Back", "Eray Cömert", 23L, 2, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "17", "Left-Back", "Loris Benito", 29L, 3, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "13", "Left-Back", "Ricardo Rodríguez", 28L, 2, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "2", "Right-Back", "Kevin Mbabu", 26L, 12, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "26", "Right-Back", "Jordan Lotomba", 22L, 6, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "3", "Right-Back", "Silvan Widmer", 28L, 4, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "6", "Defensive Midfield", "Denis Zakaria", 24L, 30, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "10", "Defensive Midfield", "Granit Xhaka", 28L, 22, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "8", "Central Midfield", "Remo Freuler", 29L, 25, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "15", "Central Midfield", "Djibril Sow", 24L, 15, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "20", "Central Midfield", "Edimilson Fernandes", 25L, 5, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "16", "Right Midfield", "Christian Fassnacht", 27L, 3, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "14", "Left Midfield", "Steven Zuber", 29L, 2, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "11", "Left Winger", "Rubén Vargas", 22L, 13, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "23", "Right Winger", "Xherdan Shaqiri", 29L, 12, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "18", "Second Striker", "Admir Mehmedi", 30L, 4, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "7", "Centre-Forward", "Breel Embolo", 24L, 16, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "9", "Centre-Forward", "Haris Seferovic", 29L, 14, "Switzerland", 26.3846153846154, 25.8292682926829,
"schweiz", "19", "Centre-Forward", "Mario Gavranovic", 31L, 2, "Switzerland", 26.3846153846154, 25.8292682926829,
"schottland", "12", "Goalkeeper", "Craig Gordon", 38L, 0.45, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "21", "Goalkeeper", "Jon McLaughlin", 33L, 0.35, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "1", "Goalkeeper", "David Marshall", 36L, 0.25, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "16", "Centre-Back", "Liam Cooper", 29L, 7, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "5", "Centre-Back", "Grant Hanley", 29L, 4, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "24", "Centre-Back", "Jack Hendry", 26L, 3, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "26", "Centre-Back", "Scott McKenna", 24L, 3, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "15", "Centre-Back", "Declan Gallagher", 30L, 0.75, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "3", "Left-Back", "Andrew Robertson", 27L, 65, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "6", "Left-Back", "Kieran Tierney", 24L, 32, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "13", "Left-Back", "Greg Taylor", 23L, 2, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "22", "Right-Back", "Nathan Patterson", 19L, 1, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "2", "Right-Back", "Stephen O'Donnell", 29L, 0.75, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "4", "Central Midfield", "Scott McTominay", 24L, 35, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "7", "Central Midfield", "John McGinn", 26L, 30, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "23", "Central Midfield", "Billy Gilmour", 20L, 10, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "17", "Central Midfield", "Stuart Armstrong", 29L, 8, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "8", "Central Midfield", "Callum McGregor", 28L, 7, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "14", "Central Midfield", "John Fleck", 29L, 5, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "18", "Central Midfield", "David Turnbull", 21L, 5, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "25", "Right Midfield", "James Forrest", 29L, 6, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "11", "Attacking Midfield", "Ryan Christie", 26L, 7, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "20", "Left Winger", "Ryan Fraser", 27L, 10, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "10", "Centre-Forward", "Che Adams", 24L, 20, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "9", "Centre-Forward", "Lyndon Dykes", 25L, 3, "Scotland", 26.8846153846154, 25.6559299944144,
"schottland", "19", "Centre-Forward", "Kevin Nisbet", 24L, 3, "Scotland", 26.8846153846154, 25.6559299944144,
"polen", "1", "Goalkeeper", "Wojciech Szczesny", 31L, 25, "Poland", 26.76, 28.0355731225296,
"polen", "12", "Goalkeeper", "Lukasz Skorupski", 30L, 3, "Poland", 26.76, 28.0355731225296,
"polen", "22", "Goalkeeper", "Lukasz Fabianski", 36L, 1, "Poland", 26.76, 28.0355731225296,
"polen", "5", "Centre-Back", "Jan Bednarek", 25L, 25, "Poland", 26.76, 28.0355731225296,
"polen", "2", "Centre-Back", "Kamil Piatkowski", 21L, 5, "Poland", 26.76, 28.0355731225296,
"polen", "3", "Centre-Back", "Pawel Dawidowicz", 26L, 4, "Poland", 26.76, 28.0355731225296,
"polen", "25", "Centre-Back", "Michal Helik", 25L, 3, "Poland", 26.76, 28.0355731225296,
"polen", "15", "Centre-Back", "Kamil Glik", 33L, 2, "Poland", 26.76, 28.0355731225296,
"polen", "26", "Left-Back", "Tymoteusz Puchacz", 22L, 3, "Poland", 26.76, 28.0355731225296,
"polen", "13", "Left-Back", "Maciej Rybus", 31L, 2, "Poland", 26.76, 28.0355731225296,
"polen", "18", "Right-Back", "Bartosz Bereszynski", 28L, 6, "Poland", 26.76, 28.0355731225296,
"polen", "4", "Right-Back", "Tomasz Kedziora", 27L, 5, "Poland", 26.76, 28.0355731225296,
"polen", "10", "Defensive Midfield", "Grzegorz Krychowiak", 31L, 15, "Poland", 26.76, 28.0355731225296,
"polen", "16", "Central Midfield", "Jakub Moder", 22L, 10, "Poland", 26.76, 28.0355731225296,
"polen", "8", "Central Midfield", "Karol Linetty", 26L, 6, "Poland", 26.76, 28.0355731225296,
"polen", "14", "Central Midfield", "Mateusz Klich", 31L, 4, "Poland", 26.76, 28.0355731225296,
"polen", "20", "Attacking Midfield", "Piotr Zielinski", 27L, 50, "Poland", 26.76, 28.0355731225296,
"polen", "6", "Attacking Midfield", "Kacper Kozlowski", 17L, 5, "Poland", 26.76, 28.0355731225296,
"polen", "21", "Left Winger", "Kamil Jozwiak", 23L, 4, "Poland", 26.76, 28.0355731225296,
"polen", "17", "Left Winger", "Przemyslaw Placheta", 23L, 2, "Poland", 26.76, 28.0355731225296,
"polen", "19", "Right Winger", "Przemyslaw Frankowski", 26L, 2, "Poland", 26.76, 28.0355731225296,
"polen", "9", "Centre-Forward", "Robert Lewandowski", 32L, 60, "Poland", 26.76, 28.0355731225296,
"polen", "11", "Centre-Forward", "Karol Swiderski", 24L, 5, "Poland", 26.76, 28.0355731225296,
"polen", "23", "Centre-Forward", "Dawid Kownacki", 24L, 3, "Poland", 26.76, 28.0355731225296,
"polen", "24", "Centre-Forward", "Jakub Swierczok", 28L, 3, "Poland", 26.76, 28.0355731225296,
"schweden", "1", "Goalkeeper", "Robin Olsen", 31L, 3, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "23", "Goalkeeper", "Kristoffer Nordfeldt", 32L, 0.9, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "12", "Goalkeeper", "Karl-Johan Johnsson", 31L, 0.7, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "3", "Centre-Back", "Victor Lindelöf", 26L, 24, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "18", "Centre-Back", "Pontus Jansson", 30L, 5, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "14", "Centre-Back", "Filip Helander", 28L, 3, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "24", "Centre-Back", "Marcus Danielson", 32L, 0.8, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "4", "Centre-Back", "Andreas Granqvist", 36L, 0.2, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "6", "Left-Back", "Ludwig Augustinsson", 27L, 10, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "5", "Left-Back", "Pierre Bengtsson", 33L, 0.35, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "16", "Right-Back", "Emil Krafth", 26L, 3, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "2", "Right-Back", "Mikael Lustig", 34L, 0.5, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "26", "Defensive Midfield", "Jens Cajuste", 21L, 5, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "8", "Defensive Midfield", "Albin Ekdal", 31L, 3, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "13", "Defensive Midfield", "Gustav Svensson", 34L, 0.3, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "19", "Central Midfield", "Mattias Svanberg", 22L, 12, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "20", "Central Midfield", "Kristoffer Olsson", 25L, 3, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "7", "Central Midfield", "Sebastian Larsson", 36L, 0.6, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "15", "Left Midfield", "Ken Sema", 27L, 4, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "10", "Left Winger", "Emil Forsberg", 29L, 20, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "17", "Left Winger", "Viktor Claesson", 29L, 10, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "21", "Right Winger", "Dejan Kulusevski", 21L, 40, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "22", "Second Striker", "Robin Quaison", 27L, 7, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "11", "Centre-Forward", "Alexander Isak", 21L, 40, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "25", "Centre-Forward", "Jordan Larsson", 24L, 15, "Sweden", 28.7307692307692, 24.5851189074641,
"schweden", "9", "Centre-Forward", "Marcus Berg", 34L, 1, "Sweden", 28.7307692307692, 24.5851189074641,
"ukraine", "23", "Goalkeeper", "Anatoliy Trubin", 19L, 8, "Ukraine", 26, 25.1859039836568,
"ukraine", "1", "Goalkeeper", "Georgiy Bushchan", 27L, 5, "Ukraine", 26, 25.1859039836568,
"ukraine", "12", "Goalkeeper", "Andriy Pyatov", 36L, 1, "Ukraine", 26, 25.1859039836568,
"ukraine", "22", "Centre-Back", "Mykola Matvienko", 25L, 11, "Ukraine", 26, 25.1859039836568,
"ukraine", "13", "Centre-Back", "Ilya Zabarnyi", 18L, 6, "Ukraine", 26, 25.1859039836568,
"ukraine", "4", "Centre-Back", "Sergiy Kryvtsov", 30L, 4, "Ukraine", 26, 25.1859039836568,
"ukraine", "25", "Centre-Back", "Denys Popov", 22L, 3, "Ukraine", 26, 25.1859039836568,
"ukraine", "17", "Left-Back", "Oleksandr Zinchenko", 24L, 25, "Ukraine", 26, 25.1859039836568,
"ukraine", "16", "Left-Back", "Vitaliy Mykolenko", 22L, 17, "Ukraine", 26, 25.1859039836568,
"ukraine", "2", "Left-Back", "Eduard Sobol", 26L, 3, "Ukraine", 26, 25.1859039836568,
"ukraine", "21", "Right-Back", "Oleksandr Karavaev", 29L, 5, "Ukraine", 26, 25.1859039836568,
"ukraine", "24", "Right-Back", "Oleksandr Tymchyk", 24L, 1, "Ukraine", 26, 25.1859039836568,
"ukraine", "6", "Defensive Midfield", "Taras Stepanenko", 31L, 7, "Ukraine", 26, 25.1859039836568,
"ukraine", "5", "Defensive Midfield", "Sergiy Sydorchuk", 30L, 4, "Ukraine", 26, 25.1859039836568,
"ukraine", "14", "Defensive Midfield", "Yevgen Makarenko", 30L, 1, "Ukraine", 26, 25.1859039836568,
"ukraine", "10", "Central Midfield", "Mykola Shaparenko", 22L, 8, "Ukraine", 26, 25.1859039836568,
"ukraine", "8", "Attacking Midfield", "Ruslan Malinovskyi", 28L, 30, "Ukraine", 26, 25.1859039836568,
"ukraine", "18", "Attacking Midfield", "Roman Bezus", 30L, 2, "Ukraine", 26, 25.1859039836568,
"ukraine", "3", "Attacking Midfield", "Georgiy Sudakov", 18L, 0.8, "Ukraine", 26, 25.1859039836568,
"ukraine", "15", "Right Winger", "Viktor Tsygankov", 23L, 25, "Ukraine", 26, 25.1859039836568,
"ukraine", "11", "Right Winger", "Marlos", 33L, 5, "Ukraine", 26, 25.1859039836568,
"ukraine", "7", "Right Winger", "Andriy Yarmolenko", 31L, 4, "Ukraine", 26, 25.1859039836568,
"ukraine", "20", "Right Winger", "Oleksandr Zubkov", 24L, 2, "Ukraine", 26, 25.1859039836568,
"ukraine", "9", "Centre-Forward", "Roman Yaremchuk", 25L, 15, "Ukraine", 26, 25.1859039836568,
"ukraine", "19", "Centre-Forward", "Artem Besedin", 25L, 2, "Ukraine", 26, 25.1859039836568,
"ukraine", "26", "Centre-Forward", "Artem Dovbyk", 24L, 1, "Ukraine", 26, 25.1859039836568,
"russland", "16", "Goalkeeper", "Matvey Safonov", 22L, 14, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "12", "Goalkeeper", "Yuri Dyupin", 33L, 3, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "1", "Goalkeeper", "Anton Shunin", 34L, 2, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "14", "Centre-Back", "Georgiy Dzhikiya", 27L, 9, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "3", "Centre-Back", "Igor Diveev", 21L, 5, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "24", "Centre-Back", "Roman Evgenjev", 22L, 4, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "5", "Centre-Back", "Andrey Semenov", 32L, 1, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "13", "Left-Back", "Fedor Kudryashov", 34L, 0.9, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "18", "Left-Back", "Yuri Zhirkov", 37L, 0.3, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "2", "Right-Back", "Mário Fernandes", 30L, 16, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "4", "Right-Back", "Vyacheslav Karavaev", 26L, 7, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "8", "Defensive Midfield", "Dmitri Barinov", 24L, 12, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "21", "Defensive Midfield", "Daniil Fomin", 24L, 6, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "26", "Defensive Midfield", "Maksim Mukhin", 19L, 2, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "11", "Central Midfield", "Roman Zobnin", 27L, 13, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "23", "Central Midfield", "Daler Kuzyaev", 28L, 8, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "7", "Central Midfield", "Magomed Ozdoev", 28L, 5, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "25", "Right Midfield", "Denis Makarov", 23L, 4, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "17", "Attacking Midfield", "Aleksandr Golovin", 25L, 28, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "15", "Attacking Midfield", "Aleksey Miranchuk", 25L, 15, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "19", "Attacking Midfield", "Rifat Zhemaletdinov", 24L, 4, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "6", "Left Winger", "Denis Cheryshev", 30L, 3, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "20", "Right Winger", "Aleksey Ionov", 32L, 2, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "9", "Centre-Forward", "Aleksandr Sobolev", 24L, 11, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "22", "Centre-Forward", "Artem Dzyuba", 32L, 11, "Russia", 27.4230769230769, 26.1673751328374,
"russland", "10", "Centre-Forward", "Anton Zabolotnyi", 30L, 2, "Russia", 27.4230769230769, 26.1673751328374,
"tschechien", "1", "Goalkeeper", "Tomas Vaclik", 32L, 4, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "23", "Goalkeeper", "Tomas Koubek", 28L, 1, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "16", "Goalkeeper", "Ales Mandous", 29L, 0.9, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "17", "Centre-Back", "David Zima", 20L, 7, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "6", "Centre-Back", "Tomas Kalas", 28L, 4, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "4", "Centre-Back", "Jakub Brabec", 28L, 2, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "3", "Centre-Back", "Ondrej Celustka", 32L, 0.7, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "18", "Left-Back", "Jan Boril", 30L, 2, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "5", "Right-Back", "Vladimir Coufal", 28L, 12, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "2", "Right-Back", "Pavel Kaderabek", 29L, 8, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "22", "Right-Back", "Ales Mateju", 25L, 1, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "15", "Defensive Midfield", "Tomas Soucek", 26L, 40, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "21", "Defensive Midfield", "Alex Kral", 23L, 10, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "9", "Defensive Midfield", "Tomas Holes", 28L, 4, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "8", "Central Midfield", "Vladimir Darida", 30L, 3, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "13", "Central Midfield", "Petr Sevcik", 27L, 3, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "26", "Central Midfield", "Michal Sadilek", 22L, 2, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "12", "Right Midfield", "Lukas Masopust", 28L, 3, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "14", "Left Midfield", "Jakub Jankto", 25L, 11, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "7", "Attacking Midfield", "Antonin Barak", 26L, 14, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "25", "Left Winger", "Jakub Pesek", 27L, 0.9, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "10", "Centre-Forward", "Patrik Schick", 25L, 23, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "19", "Centre-Forward", "Adam Hlozek", 18L, 17, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "11", "Centre-Forward", "Michael Krmencik", 28L, 4, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "20", "Centre-Forward", "Matej Vydra", 29L, 3, "Czechia", 27.0384615384615, 25.4644628099174,
"tschechien", "24", "Centre-Forward", "Tomas Pekhart", 32L, 1, "Czechia", 27.0384615384615, 25.4644628099174,
"wales", "12", "Goalkeeper", "Danny Ward", 28L, 6, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "1", "Goalkeeper", "Wayne Hennessey", 34L, 1, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "21", "Goalkeeper", "Adam Davies", 28L, 0.7, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "15", "Centre-Back", "Ethan Ampadu", 20L, 15, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "6", "Centre-Back", "Joe Rodon", 23L, 10, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "24", "Centre-Back", "Ben Cabango", 21L, 7, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "22", "Centre-Back", "Chris Mepham", 23L, 6, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "5", "Centre-Back", "Tom Lockyer", 26L, 1, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "4", "Left-Back", "Ben Davies", 28L, 16, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "17", "Left-Back", "Rhys Norrington-Davies", 22L, 1, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "3", "Right-Back", "Neco Williams", 20L, 8, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "14", "Right-Back", "Connor Roberts", 25L, 4, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "2", "Right-Back", "Chris Gunter", 31L, 0.8, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "26", "Defensive Midfield", "Matt Smith", 21L, 1, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "10", "Central Midfield", "Aaron Ramsey", 30L, 14, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "7", "Central Midfield", "Joe Allen", 31L, 2, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "23", "Central Midfield", "Dylan Levitt", 20L, 0.65, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "16", "Central Midfield", "Joe Morrell", 24L, 0.4, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "18", "Attacking Midfield", "Jonathan Williams", 27L, 0.5, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "25", "Attacking Midfield", "Rubin Colwill", 19L, 0.5, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "-", "Attacking Midfield", "Mark Jones", 36L, 0.3, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "20", "Left Winger", "Daniel James", 23L, 18, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "11", "Right Winger", "Gareth Bale", 31L, 18, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "8", "Right Winger", "Harry Wilson", 24L, 17, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "19", "Right Winger", "David Brooks", 23L, 16, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "9", "Second Striker", "Tyler Roberts", 22L, 6, "Wales", 25.4814814814815, 25.0031276656241,
"wales", "13", "Centre-Forward", "Kieffer Moore", 28L, 5, "Wales", 25.4814814814815, 25.0031276656241,
"slowakei", "1", "Goalkeeper", "Martin Dubravka", 32L, 5, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "23", "Goalkeeper", "Marek Rodak", 24L, 5, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "12", "Goalkeeper", "Dusan Kuciak", 36L, 0.2, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "14", "Centre-Back", "Milan Skriniar", 26L, 60, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "4", "Centre-Back", "Martin Valjent", 25L, 5, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "3", "Centre-Back", "Denis Vavro", 25L, 4, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "16", "Centre-Back", "David Hancko", 23L, 2, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "5", "Centre-Back", "Lubomir Satka", 25L, 2, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "2", "Right-Back", "Peter Pekarik", 34L, 0.8, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "24", "Right-Back", "Martin Koscelnik", 26L, 0.6, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "15", "Right-Back", "Tomas Hubocan", 35L, 0.3, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "22", "Defensive Midfield", "Stanislav Lobotka", 26L, 9, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "25", "Defensive Midfield", "Jakub Hromada", 25L, 1, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "13", "Central Midfield", "Patrik Hrosovsky", 29L, 5, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "11", "Central Midfield", "Lászlo Bénes", 23L, 4, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "6", "Central Midfield", "Jan Gregus", 30L, 3, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "17", "Central Midfield", "Marek Hamsik", 33L, 3, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "19", "Central Midfield", "Juraj Kucka", 34L, 3, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "8", "Attacking Midfield", "Ondrej Duda", 26L, 8, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "10", "Attacking Midfield", "Tomas Suslov", 19L, 1, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "18", "Left Winger", "Lukas Haraslin", 25L, 1, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "20", "Left Winger", "Robert Mak", 30L, 1, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "7", "Left Winger", "Vladimir Weiss", 31L, 0.8, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "9", "Centre-Forward", "Robert Bozenik", 21L, 2, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "26", "Centre-Forward", "Ivan Schranz", 27L, 1, "Slovakia", 27.8076923076923, 26.5323460639127,
"slowakei", "21", "Centre-Forward", "Michal Duris", 33L, 0.6, "Slovakia", 27.8076923076923, 26.5323460639127,
"ungarn", "1", "Goalkeeper", "Péter Gulácsi", 31L, 13, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "12", "Goalkeeper", "Dénes Dibusz", 30L, 2, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "22", "Goalkeeper", "Ádám Bogdán", 33L, 0.4, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "6", "Centre-Back", "Willi Orban", 28L, 16, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "4", "Centre-Back", "Attila Szalai", 23L, 7, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "2", "Centre-Back", "Ádám Lang", 28L, 1, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "3", "Centre-Back", "Ákos Kecskés", 25L, 0.8, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "7", "Right-Back", "Loïc Nego", 30L, 2, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "21", "Right-Back", "Endre Botka", 26L, 1, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "5", "Right-Back", "Attila Fiola", 31L, 0.7, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "14", "Right-Back", "Gergő Lovrencsics", 32L, 0.65, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "26", "Right-Back", "Bendegúz Bolla", 21L, 0.6, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "8", "Defensive Midfield", "Ádám Nagy", 26L, 2, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "18", "Central Midfield", "Dávid Sigér", 30L, 1, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "13", "Central Midfield", "András Schäfer", 22L, 0.7, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "15", "Attacking Midfield", "László Kleinheisler", 27L, 2, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "16", "Attacking Midfield", "Dániel Gazdag", 25L, 1, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "19", "Left Winger", "Kevin Varga", 25L, 2, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "24", "Left Winger", "Szabolcs Schön", 20L, 1, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "10", "Left Winger", "Tamás Cseri", 33L, 0.4, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "20", "Right Winger", "Roland Sallai", 24L, 13, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "17", "Right Winger", "Roland Varga", 31L, 0.7, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "11", "Centre-Forward", "Filip Holender", 26L, 1, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "23", "Centre-Forward", "Nemanja Nikolics", 33L, 1, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "25", "Centre-Forward", "János Hahn", 26L, 0.75, "Hungary", 27.6538461538462, 27.1747572815534,
"ungarn", "9", "Centre-Forward", "Ádám Szalai", 33L, 0.4, "Hungary", 27.6538461538462, 27.1747572815534,
"nordmazedonien", "1", "Goalkeeper", "Stole Dimitrievski", 27L, 1, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "22", "Goalkeeper", "Damjan Siskovski", 26L, 0.4, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "12", "Goalkeeper", "Risto Jankov", 22L, 0.3, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "14", "Centre-Back", "Darko Velkovski", 26L, 2, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "6", "Centre-Back", "Visar Musliu", 26L, 1, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "2", "Centre-Back", "Egzon Bejtulai", 27L, 0.8, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "4", "Centre-Back", "Kire Ristevski", 30L, 0.5, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "3", "Centre-Back", "Gjoko Zajkov", 26L, 0.25, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "8", "Left-Back", "Ezgjan Alioski", 29L, 5, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "13", "Right-Back", "Stefan Ristovski", 29L, 2, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "5", "Defensive Midfield", "Arijan Ademi", 30L, 8, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "20", "Defensive Midfield", "Stefan Spirovski", 30L, 0.45, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "16", "Central Midfield", "Boban Nikolov", 26L, 0.8, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "21", "Attacking Midfield", "Eljif Elmas", 21L, 17, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "17", "Attacking Midfield", "Enis Bardhi", 25L, 15, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "24", "Attacking Midfield", "Daniel Avramovski", 26L, 1, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "15", "Attacking Midfield", "Tihomir Kostadinov", 25L, 0.45, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "11", "Attacking Midfield", "Ferhan Hasani", 31L, 0.3, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "25", "Left Winger", "Darko Churlinov", 20L, 1, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "9", "Left Winger", "Aleksandar Trajkovski", 28L, 0.4, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "23", "Left Winger", "Marjan Radeski", 26L, 0.35, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "10", "Second Striker", "Goran Pandev", 37L, 0.5, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "19", "Second Striker", "Krste Velkoski", 33L, 100, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "7", "Centre-Forward", "Ivan Trickovski", 34L, 0.7, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "26", "Centre-Forward", "Milan Ristovski", 23L, 0.5, "North Macedonia", 27.1923076923077, 30.1352279825109,
"nordmazedonien", "18", "Centre-Forward", "Vlatko Stojanovski", 24L, 0.4, "North Macedonia", 27.1923076923077, 30.1352279825109,
"finnland", "1", "Goalkeeper", "Lukas Hradecky", 31L, 6, "Finland", 27.5, 27.2488151658768,
"finnland", "12", "Goalkeeper", "Jesse Joronen", 28L, 1, "Finland", 27.5, 27.2488151658768,
"finnland", "23", "Goalkeeper", "Anssi Jaakkola", 34L, 0.2, "Finland", 27.5, 27.2488151658768,
"finnland", "5", "Centre-Back", "Leo Väisänen", 23L, 1, "Finland", 27.5, 27.2488151658768,
"finnland", "16", "Centre-Back", "Thomas Lam", 27L, 0.65, "Finland", 27.5, 27.2488151658768,
"finnland", "4", "Centre-Back", "Joona Toivio", 33L, 0.6, "Finland", 27.5, 27.2488151658768,
"finnland", "2", "Centre-Back", "Paulus Arajuuri", 33L, 0.45, "Finland", 27.5, 27.2488151658768,
"finnland", "3", "Centre-Back", "Daniel O'Shaughnessy", 26L, 0.45, "Finland", 27.5, 27.2488151658768,
"finnland", "25", "Centre-Back", "Robert Ivanov", 26L, 0.35, "Finland", 27.5, 27.2488151658768,
"finnland", "18", "Left-Back", "Jere Uronen", 26L, 2, "Finland", 27.5, 27.2488151658768,
"finnland", "15", "Left-Back", "Niko Hämäläinen", 24L, 0.5, "Finland", 27.5, 27.2488151658768,
"finnland", "22", "Left-Back", "Jukka Raitala", 32L, 0.5, "Finland", 27.5, 27.2488151658768,
"finnland", "17", "Right-Back", "Nikolai Alho", 28L, 0.45, "Finland", 27.5, 27.2488151658768,
"finnland", "6", "Defensive Midfield", "Glen Kamara", 25L, 6, "Finland", 27.5, 27.2488151658768,
"finnland", "14", "Defensive Midfield", "Tim Sparv", 34L, 0.25, "Finland", 27.5, 27.2488151658768,
"finnland", "11", "Central Midfield", "Rasmus Schüller", 30L, 0.7, "Finland", 27.5, 27.2488151658768,
"finnland", "19", "Central Midfield", "Joni Kauko", 30L, 0.4, "Finland", 27.5, 27.2488151658768,
"finnland", "8", "Left Midfield", "Robin Lod", 28L, 3, "Finland", 27.5, 27.2488151658768,
"finnland", "9", "Attacking Midfield", "Fredrik Jensen", 23L, 2, "Finland", 27.5, 27.2488151658768,
"finnland", "24", "Attacking Midfield", "Onni Valakari", 21L, 1, "Finland", 27.5, 27.2488151658768,
"finnland", "21", "Left Winger", "Lassi Lappalainen", 22L, 0.8, "Finland", 27.5, 27.2488151658768,
"finnland", "7", "Left Winger", "Robert Taylor", 26L, 0.6, "Finland", 27.5, 27.2488151658768,
"finnland", "13", "Left Winger", "Pyry Soiri", 26L, 0.3, "Finland", 27.5, 27.2488151658768,
"finnland", "10", "Centre-Forward", "Teemu Pukki", 31L, 7, "Finland", 27.5, 27.2488151658768,
"finnland", "26", "Centre-Forward", "Marcus Forss", 22L, 4, "Finland", 27.5, 27.2488151658768,
"finnland", "20", "Centre-Forward", "Joel Pohjanpalo", 26L, 2, "Finland", 27.5, 27.2488151658768
)
Raw
gistfile1.txt
#===============================================================================
# 2021-06-23 -- Rostock Retreat
# Dataviz challenge -- prepare EURO 2020 data
# Ilya Kashnitsky, [email protected]
#===============================================================================
library(tidyverse)
library(magrittr)
library(rvest)
library(countrycode)
# Get the detailed team squads data from Transfermarkt
# https://www.transfermarkt.com/euro-2020/teilnehmer/pokalwettbewerb/EM20
# try make it work for one country
page <- read_html("https://www.transfermarkt.com/england/startseite/verein/3299")
table <- html_nodes(page, "table") %>% #list all tables
extract2(., str_which(. ,"Age")) %>% # select the one needed
html_table(fill = T) %>% # convert to a table
set_names(letters[1:9]) %>%
transmute(
no = a,
position = e,
name = f,
age = g,
market_value = i %>% str_extract("[0-9]+")
) %>%
drop_na()
# did it work?
table %>% view
# a function too process them in a batch
get_team <- function(url){
cntr <- url %>%
str_remove_all("[0-9]+") %>%
str_remove("https://www.transfermarkt.com/") %>%
str_remove("/startseite/verein/")
page <- read_html(url)
table <- html_nodes(page, "table") %>% #list all tables
extract2(., str_which(. ,"Age")) %>% # select the one needed
html_table(fill = T) %>% # convert to a table
set_names(letters[1:9]) %>%
transmute(
country = cntr,
no = a %>% paste,
position = e,
name = f,
age = g,
market_value = i %>% str_extract("[0-9]+") %>% as.numeric()
) %>%
drop_na()
}
# check
"https://www.transfermarkt.com/england/startseite/verein/3299" %>% get_team %>% view
links <- c(
"https://www.transfermarkt.com/england/startseite/verein/3299",
"https://www.transfermarkt.com/frankreich/startseite/verein/3377",
"https://www.transfermarkt.com/deutschland/startseite/verein/3262",
"https://www.transfermarkt.com/spanien/startseite/verein/3375",
"https://www.transfermarkt.com/portugal/startseite/verein/3300",
"https://www.transfermarkt.com/italien/startseite/verein/3376",
"https://www.transfermarkt.com/belgien/startseite/verein/3382",
"https://www.transfermarkt.com/niederlande/startseite/verein/3379",
"https://www.transfermarkt.com/kroatien/startseite/verein/3556",
"https://www.transfermarkt.com/turkei/startseite/verein/3381",
"https://www.transfermarkt.com/osterreich/startseite/verein/3383",
"https://www.transfermarkt.com/danemark/startseite/verein/3436",
"https://www.transfermarkt.com/schweiz/startseite/verein/3384",
"https://www.transfermarkt.com/schottland/startseite/verein/3380",
"https://www.transfermarkt.com/polen/startseite/verein/3442",
"https://www.transfermarkt.com/schweden/startseite/verein/3557",
"https://www.transfermarkt.com/ukraine/startseite/verein/3699",
"https://www.transfermarkt.com/russland/startseite/verein/3448",
"https://www.transfermarkt.com/tschechien/startseite/verein/3445",
"https://www.transfermarkt.com/wales/startseite/verein/3864",
"https://www.transfermarkt.com/slowakei/startseite/verein/3503",
"https://www.transfermarkt.com/ungarn/startseite/verein/3468",
"https://www.transfermarkt.com/nordmazedonien/startseite/verein/5148",
"https://www.transfermarkt.com/finnland/startseite/verein/3443"
)
raw <- links %>% map_df(get_team)
# Good idea to save the raw scraped data
# save(raw, file = "your-path/raw-data.rda")
euro_2020_players <- raw %>%
mutate(
# fix market_value in thousands
market_value = case_when(
market_value %>% is_greater_than(160) ~ market_value %>% divide_by(1000),
TRUE ~ market_value
),
# fix country names
cntr = country %>%
str_to_title %>%
countrycode(origin = "country.name.de",destination = "country.name"),
cntr = case_when(
country == "schottland" ~ "Scotland",
country == "turkei" ~ "Turkey",
country == "england" ~ "England",
country == "wales" ~ "Wales",
TRUE ~ cntr
)
) %>%
group_by(cntr) %>%
mutate(
avg_age = age %>% mean,
avg_age_mv = weighted.mean(age, market_value)
) %>%
ungroup() %>%
mutate(cntr = cntr %>% as_factor %>% fct_reorder(avg_age))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment