Skip to content

Instantly share code, notes, and snippets.

@PaulC91
Last active July 19, 2018 13:28
Show Gist options
  • Select an option

  • Save PaulC91/4d5fb65b44ca0fc95a9681ad50fd1c5d to your computer and use it in GitHub Desktop.

Select an option

Save PaulC91/4d5fb65b44ca0fc95a9681ad50fd1c5d to your computer and use it in GitHub Desktop.

Revisions

  1. PaulC91 renamed this gist Jun 13, 2018. 1 changed file with 0 additions and 0 deletions.
    File renamed without changes.
  2. PaulC91 renamed this gist Jun 13, 2018. 1 changed file with 0 additions and 0 deletions.
    File renamed without changes.
  3. PaulC91 revised this gist Jun 13, 2018. 1 changed file with 737 additions and 0 deletions.
    737 changes: 737 additions & 0 deletions wc_graph.csv
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,737 @@
    id,Player,Country,Club
    1,Essam El-Hadary (captain),Egypt,Al-Taawoun
    2,Ali Gabr,Egypt,West Bromwich Albion
    3,Ahmed Elmohamady,Egypt,Aston Villa
    4,Omar Gaber,Egypt,Los Angeles FC
    5,Sam Morsy,Egypt,Wigan Athletic
    6,Ahmed Hegazi,Egypt,West Bromwich Albion
    7,Ahmed Fathy,Egypt,Al Ahly
    8,Tarek Hamed,Egypt,Zamalek
    9,Marwan Mohsen,Egypt,Al Ahly
    10,Mohamed Salah,Egypt,Liverpool
    11,Kahraba,Egypt,Al-Ittihad
    12,Ayman Ashraf,Egypt,Al Ahly
    13,Mohamed Abdel-Shafy,Egypt,Al-Fateh
    14,Ramadan Sobhi,Egypt,Stoke City
    15,Mahmoud Hamdy,Egypt,Zamalek
    16,Sherif Ekramy,Egypt,Al Ahly
    17,Mohamed Elneny,Egypt,Arsenal
    18,Shikabala,Egypt,Al-Raed
    19,Abdallah Said,Egypt,KuPS
    20,Saad Samir,Egypt,Al Ahly
    21,Trézéguet,Egypt,Kasımpaşa
    22,Amr Warda,Egypt,Atromitos
    23,Mohamed El-Shenawy,Egypt,Al Ahly
    24,Igor Akinfeev (captain),Russia,CSKA Moscow
    25,Mário Fernandes,Russia,CSKA Moscow
    26,Ilya Kutepov,Russia,Spartak Moscow
    27,Sergei Ignashevich,Russia,CSKA Moscow
    28,Andrei Semyonov,Russia,Akhmat Grozny
    29,Denis Cheryshev,Russia,Villarreal
    30,Daler Kuzyayev,Russia,Zenit Saint Petersburg
    31,Yury Gazinsky,Russia,Krasnodar
    32,Alan Dzagoev,Russia,CSKA Moscow
    33,Fyodor Smolov,Russia,Krasnodar
    34,Roman Zobnin,Russia,Spartak Moscow
    35,Andrey Lunyov,Russia,Zenit Saint Petersburg
    36,Fyodor Kudryashov,Russia,Rubin Kazan
    37,Vladimir Granat,Russia,Rubin Kazan
    38,Aleksei Miranchuk,Russia,Lokomotiv Moscow
    39,Anton Miranchuk,Russia,Lokomotiv Moscow
    40,Aleksandr Golovin,Russia,CSKA Moscow
    41,Yuri Zhirkov,Russia,Zenit Saint Petersburg
    42,Aleksandr Samedov,Russia,Spartak Moscow
    43,Vladimir Gabulov,Russia,Club Brugge
    44,Aleksandr Yerokhin,Russia,Zenit Saint Petersburg
    45,Artem Dzyuba,Russia,Arsenal Tula
    46,Igor Smolnikov,Russia,Zenit Saint Petersburg
    47,Abdullah Al-Mayouf,Saudi Arabia,Al-Hilal
    48,Mansoor Al-Harbi,Saudi Arabia,Al-Ahli
    49,Osama Hawsawi (captain),Saudi Arabia,Al-Hilal
    50,Ali Al-Bulaihi,Saudi Arabia,Al-Hilal
    51,Omar Hawsawi,Saudi Arabia,Al-Nassr
    52,Mohammed Al-Breik,Saudi Arabia,Al-Hilal
    53,Salman Al-Faraj,Saudi Arabia,Al-Hilal
    54,Yahya Al-Shehri,Saudi Arabia,Leganés
    55,Hattan Bahebri,Saudi Arabia,Al-Shabab
    56,Mohammad Al-Sahlawi,Saudi Arabia,Al-Nassr
    57,Abdulmalek Al-Khaibri,Saudi Arabia,Al-Hilal
    58,Mohamed Kanno,Saudi Arabia,Al-Hilal
    59,Yasser Al-Shahrani,Saudi Arabia,Al-Hilal
    60,Abdullah Otayf,Saudi Arabia,Al-Hilal
    61,Abdullah Al-Khaibari,Saudi Arabia,Al-Shabab
    62,Housain Al-Mogahwi,Saudi Arabia,Al-Ahli
    63,Taisir Al-Jassim,Saudi Arabia,Al-Ahli
    64,Salem Al-Dawsari,Saudi Arabia,Villarreal
    65,Fahad Al-Muwallad,Saudi Arabia,Levante
    66,Muhannad Assiri,Saudi Arabia,Al-Ahli
    67,Yasser Al-Mosailem,Saudi Arabia,Al-Ahli
    68,Mohammed Al-Owais,Saudi Arabia,Al-Ahli
    69,Motaz Hawsawi,Saudi Arabia,Al-Ahli
    70,Fernando Muslera,Uruguay,Galatasaray
    71,José Giménez,Uruguay,Atlético Madrid
    72,Diego Godín (captain),Uruguay,Atlético Madrid
    73,Guillermo Varela,Uruguay,Peñarol
    74,Carlos Sánchez,Uruguay,Monterrey
    75,Rodrigo Bentancur,Uruguay,Juventus
    76,Cristian Rodríguez,Uruguay,Peñarol
    77,Nahitan Nández,Uruguay,Boca Juniors
    78,Luis Suárez,Uruguay,Barcelona
    79,Giorgian De Arrascaeta,Uruguay,Cruzeiro
    80,Cristhian Stuani,Uruguay,Girona
    81,Martín Campaña,Uruguay,Independiente
    82,Gastón Silva,Uruguay,Independiente
    83,Lucas Torreira,Uruguay,Sampdoria
    84,Matías Vecino,Uruguay,Inter Milan
    85,Maxi Pereira,Uruguay,Porto
    86,Diego Laxalt,Uruguay,Genoa
    87,Maxi Gómez,Uruguay,Celta Vigo
    88,Sebastián Coates,Uruguay,Sporting CP
    89,Jonathan Urretaviscaya,Uruguay,Monterrey
    90,Edinson Cavani,Uruguay,Paris Saint-Germain
    91,Martín Cáceres,Uruguay,Lazio
    92,Martín Silva,Uruguay,Vasco da Gama
    93,Alireza Beiranvand,Iran,Persepolis
    94,Mehdi Torabi,Iran,Saipa
    95,Ehsan Hajsafi,Iran,Olympiacos
    96,Rouzbeh Cheshmi,Iran,Esteghlal
    97,Milad Mohammadi,Iran,Akhmat Grozny
    98,Saeid Ezatolahi,Iran,Amkar Perm
    99,Masoud Shojaei (captain),Iran,AEK Athens
    100,Morteza Pouraliganji,Iran,Al-Sadd
    101,Omid Ebrahimi,Iran,Esteghlal
    102,Karim Ansarifard,Iran,Olympiacos
    103,Vahid Amiri,Iran,Persepolis
    104,Mohammad Rashid Mazaheri,Iran,Zob Ahan
    105,Mohammad Reza Khanzadeh,Iran,Padideh
    106,Saman Ghoddos,Iran,Östersund
    107,Pejman Montazeri,Iran,Esteghlal
    108,Reza Ghoochannejhad,Iran,Heerenveen
    109,Mehdi Taremi,Iran,Al-Gharafa
    110,Alireza Jahanbakhsh,Iran,AZ
    111,Majid Hosseini,Iran,Esteghlal
    112,Sardar Azmoun,Iran,Rubin Kazan
    113,Ashkan Dejagah,Iran,Nottingham Forest
    114,Amir Abedzadeh,Iran,Marítimo
    115,Ramin Rezaeian,Iran,Oostende
    116,Yassine Bounou,Morocco,Girona
    117,Achraf Hakimi,Morocco,Real Madrid
    118,Hamza Mendyl,Morocco,Lille
    119,Manuel da Costa,Morocco,İstanbul Başakşehir
    120,Medhi Benatia (captain),Morocco,Juventus
    121,Romain Saïss,Morocco,Wolverhampton Wanderers
    122,Hakim Ziyech,Morocco,Ajax
    123,Karim El Ahmadi,Morocco,Feyenoord
    124,Ayoub El Kaabi,Morocco,RS Berkane
    125,Younès Belhanda,Morocco,Galatasaray
    126,Fayçal Fajr,Morocco,Getafe
    127,Munir Mohamedi,Morocco,Numancia
    128,Khalid Boutaïb,Morocco,Yeni Malatyaspor
    129,Mbark Boussoufa,Morocco,Al-Jazira
    130,Youssef Aït Bennasser,Morocco,Caen
    131,Nordin Amrabat,Morocco,Leganés
    132,Nabil Dirar,Morocco,Fenerbahçe
    133,Amine Harit,Morocco,Schalke 04
    134,Youssef En-Nesyri,Morocco,Málaga
    135,Aziz Bouhaddouz,Morocco,FC St. Pauli
    136,Sofyan Amrabat,Morocco,Feyenoord
    137,Ahmed Reda Tagnaouti,Morocco,IR Tanger
    138,Mehdi Carcela,Morocco,Standard Liège
    139,Rui Patrício,Portugal,Sporting CP
    140,Bruno Alves,Portugal,Rangers
    141,Pepe,Portugal,Beşiktaş
    142,Manuel Fernandes,Portugal,Lokomotiv Moscow
    143,Raphaël Guerreiro,Portugal,Borussia Dortmund
    144,José Fonte,Portugal,Dalian Yifang
    145,Cristiano Ronaldo (captain),Portugal,Real Madrid
    146,João Moutinho,Portugal,Monaco
    147,André Silva,Portugal,Milan
    148,João Mário,Portugal,West Ham United
    149,Bernardo Silva,Portugal,Manchester City
    150,Anthony Lopes,Portugal,Lyon
    151,Rúben Dias,Portugal,Benfica
    152,William Carvalho,Portugal,Sporting CP
    153,Ricardo Pereira,Portugal,Porto
    154,Bruno Fernandes,Portugal,Sporting CP
    155,Gonçalo Guedes,Portugal,Valencia
    156,Gelson Martins,Portugal,Sporting CP
    157,Mário Rui,Portugal,Napoli
    158,Ricardo Quaresma,Portugal,Beşiktaş
    159,Cédric,Portugal,Southampton
    160,Beto,Portugal,Göztepe
    161,Adrien Silva,Portugal,Leicester City
    162,David de Gea,Spain,Manchester United
    163,Dani Carvajal,Spain,Real Madrid
    164,Gerard Piqué,Spain,Barcelona
    165,Nacho,Spain,Real Madrid
    166,Sergio Busquets,Spain,Barcelona
    167,Andrés Iniesta,Spain,Barcelona
    168,Saúl,Spain,Atlético Madrid
    169,Koke,Spain,Atlético Madrid
    170,Rodrigo,Spain,Valencia
    171,Thiago,Spain,Bayern Munich
    172,Lucas Vázquez,Spain,Real Madrid
    173,Álvaro Odriozola,Spain,Real Sociedad
    174,Kepa Arrizabalaga,Spain,Athletic Bilbao
    175,César Azpilicueta,Spain,Chelsea
    176,Sergio Ramos (captain),Spain,Real Madrid
    177,Nacho Monreal,Spain,Arsenal
    178,Iago Aspas,Spain,Celta Vigo
    179,Jordi Alba,Spain,Barcelona
    180,Diego Costa,Spain,Atlético Madrid
    181,Marco Asensio,Spain,Real Madrid
    182,David Silva,Spain,Manchester City
    183,Isco,Spain,Real Madrid
    184,Pepe Reina,Spain,Napoli
    185,Mathew Ryan,Australia,Brighton & Hove Albion
    186,Milos Degenek,Australia,Yokohama F. Marinos
    187,James Meredith,Australia,Millwall
    188,Tim Cahill,Australia,Millwall
    189,Mark Milligan,Australia,Al-Ahli
    190,Matthew Jurman,Australia,Suwon Samsung Bluewings
    191,Mathew Leckie,Australia,Hertha BSC
    192,Massimo Luongo,Australia,Queens Park Rangers
    193,Tomi Juric,Australia,Luzern
    194,Robbie Kruse,Australia,VfL Bochum
    195,Andrew Nabbout,Australia,Urawa Red Diamonds
    196,Brad Jones,Australia,Feyenoord
    197,Aaron Mooy,Australia,Huddersfield Town
    198,Jamie Maclaren,Australia,Hibernian
    199,Mile Jedinak (captain),Australia,Aston Villa
    200,Aziz Behich,Australia,Bursaspor
    201,Daniel Arzani,Australia,Melbourne City
    202,Danny Vukovic,Australia,Genk
    203,Josh Risdon,Australia,Western Sydney Wanderers
    204,Trent Sainsbury,Australia,Grasshoppers
    205,Dimitri Petratos,Australia,Newcastle Jets
    206,Jackson Irvine,Australia,Hull City
    207,Tom Rogic,Australia,Celtic
    208,Kasper Schmeichel,Denmark,Leicester City
    209,Michael Krohn-Dehli,Denmark,Deportivo La Coruña
    210,Jannik Vestergaard,Denmark,Borussia Mönchengladbach
    211,Simon Kjær (captain),Denmark,Sevilla
    212,Jonas Knudsen,Denmark,Ipswich Town
    213,Andreas Christensen,Denmark,Chelsea
    214,William Kvist,Denmark,Copenhagen
    215,Thomas Delaney,Denmark,Werder Bremen
    216,Nicolai Jørgensen,Denmark,Feyenoord
    217,Christian Eriksen,Denmark,Tottenham Hotspur
    218,Martin Braithwaite,Denmark,Bordeaux
    219,Kasper Dolberg,Denmark,Ajax
    220,Mathias Jørgensen,Denmark,Huddersfield Town
    221,Henrik Dalsgaard,Denmark,Brentford
    222,Viktor Fischer,Denmark,Copenhagen
    223,Jonas Lössl,Denmark,Huddersfield Town
    224,Jens Stryger Larsen,Denmark,Udinese
    225,Lukas Lerager,Denmark,Bordeaux
    226,Lasse Schöne,Denmark,Ajax
    227,Yussuf Poulsen,Denmark,RB Leipzig
    228,Andreas Cornelius,Denmark,Atalanta
    229,Frederik Rønnow,Denmark,Brøndby
    230,Pione Sisto,Denmark,Celta Vigo
    231,Hugo Lloris (captain),France,Tottenham Hotspur
    232,Benjamin Pavard,France,VfB Stuttgart
    233,Presnel Kimpembe,France,Paris Saint-Germain
    234,Raphaël Varane,France,Real Madrid
    235,Samuel Umtiti,France,Barcelona
    236,Paul Pogba,France,Manchester United
    237,Antoine Griezmann,France,Atlético Madrid
    238,Thomas Lemar,France,Monaco
    239,Olivier Giroud,France,Chelsea
    240,Kylian Mbappé,France,Paris Saint-Germain
    241,Ousmane Dembélé,France,Barcelona
    242,Corentin Tolisso,France,Bayern Munich
    243,N'Golo Kanté,France,Chelsea
    244,Blaise Matuidi,France,Juventus
    245,Steven Nzonzi,France,Sevilla
    246,Steve Mandanda,France,Marseille
    247,Adil Rami,France,Marseille
    248,Nabil Fekir,France,Lyon
    249,Djibril Sidibé,France,Monaco
    250,Florian Thauvin,France,Marseille
    251,Lucas Hernández,France,Atlético Madrid
    252,Benjamin Mendy,France,Manchester City
    253,Alphonse Areola,France,Paris Saint-Germain
    254,Pedro Gallese,Peru,Veracruz
    255,Alberto Rodríguez,Peru,Atlético Junior
    256,Aldo Corzo,Peru,Universitario
    257,Anderson Santamaría,Peru,Puebla
    258,Miguel Araujo,Peru,Alianza Lima
    259,Miguel Trauco,Peru,Flamengo
    260,Paolo Hurtado,Peru,Vitória de Guimarães
    261,Christian Cueva,Peru,São Paulo
    262,Paolo Guerrero (captain),Peru,Flamengo
    263,Jefferson Farfán,Peru,Lokomotiv Moscow
    264,Raúl Ruidíaz,Peru,Morelia
    265,Carlos Cáceda,Peru,Deportivo Municipal
    266,Renato Tapia,Peru,Feyenoord
    267,Andy Polo,Peru,Portland Timbers
    268,Christian Ramos,Peru,Veracruz
    269,Wilder Cartagena,Peru,Veracruz
    270,Luis Advíncula,Peru,Lobos BUAP
    271,André Carrillo,Peru,Watford
    272,Yoshimar Yotún,Peru,Orlando City
    273,Edison Flores,Peru,AaB
    274,José Carvallo,Peru,UTC
    275,Nilson Loyola,Peru,Melgar
    276,Pedro Aquino,Peru,Lobos BUAP
    277,Nahuel Guzmán,Argentina,UANL
    278,Gabriel Mercado,Argentina,Sevilla
    279,Nicolás Tagliafico,Argentina,Ajax
    280,Cristian Ansaldi,Argentina,Torino
    281,Lucas Biglia,Argentina,Milan
    282,Federico Fazio,Argentina,Roma
    283,Éver Banega,Argentina,Sevilla
    284,Marcos Acuña,Argentina,Sporting CP
    285,Gonzalo Higuaín,Argentina,Juventus
    286,Lionel Messi (captain),Argentina,Barcelona
    287,Ángel Di María,Argentina,Paris Saint-Germain
    288,Franco Armani,Argentina,River Plate
    289,Maximiliano Meza,Argentina,Independiente
    290,Javier Mascherano,Argentina,Hebei China Fortune
    291,Enzo Pérez,Argentina,River Plate
    292,Marcos Rojo,Argentina,Manchester United
    293,Nicolás Otamendi,Argentina,Manchester City
    294,Eduardo Salvio,Argentina,Benfica
    295,Sergio Agüero,Argentina,Manchester City
    296,Giovani Lo Celso,Argentina,Paris Saint-Germain
    297,Paulo Dybala,Argentina,Juventus
    298,Cristian Pavón,Argentina,Boca Juniors
    299,Willy Caballero,Argentina,Chelsea
    300,Dominik Livaković,Croatia,Dinamo Zagreb
    301,Šime Vrsaljko,Croatia,Atlético Madrid
    302,Ivan Strinić,Croatia,Sampdoria
    303,Ivan Perišić,Croatia,Inter Milan
    304,Vedran Ćorluka,Croatia,Lokomotiv Moscow
    305,Dejan Lovren,Croatia,Liverpool
    306,Ivan Rakitić,Croatia,Barcelona
    307,Mateo Kovačić,Croatia,Real Madrid
    308,Andrej Kramarić,Croatia,1899 Hoffenheim
    309,Luka Modrić (captain),Croatia,Real Madrid
    310,Marcelo Brozović,Croatia,Inter Milan
    311,Lovre Kalinić,Croatia,Gent
    312,Tin Jedvaj,Croatia,Bayer Leverkusen
    313,Filip Bradarić,Croatia,Rijeka
    314,Duje Ćaleta-Car,Croatia,Red Bull Salzburg
    315,Nikola Kalinić,Croatia,Milan
    316,Mario Mandžukić,Croatia,Juventus
    317,Ante Rebić,Croatia,Eintracht Frankfurt
    318,Milan Badelj,Croatia,Fiorentina
    319,Marko Pjaca,Croatia,Schalke 04
    320,Domagoj Vida,Croatia,Beşiktaş
    321,Josip Pivarić,Croatia,Dynamo Kyiv
    322,Danijel Subašić,Croatia,Monaco
    323,Hannes Þór Halldórsson,Iceland,Randers
    324,Birkir Már Sævarsson,Iceland,Valur
    325,Samúel Friðjónsson,Iceland,Vålerenga
    326,Albert Guðmundsson,Iceland,PSV Eindhoven
    327,Sverrir Ingi Ingason,Iceland,Rostov
    328,Ragnar Sigurðsson,Iceland,Rostov
    329,Jóhann Berg Guðmundsson,Iceland,Burnley
    330,Birkir Bjarnason,Iceland,Aston Villa
    331,Björn Bergmann Sigurðarson,Iceland,Rostov
    332,Gylfi Sigurðsson,Iceland,Everton
    333,Alfreð Finnbogason,Iceland,FC Augsburg
    334,Frederik Schram,Iceland,Roskilde
    335,Rúnar Alex Rúnarsson,Iceland,Nordsjælland
    336,Kári Árnason,Iceland,Aberdeen
    337,Hólmar Örn Eyjólfsson,Iceland,Levski Sofia
    338,Ólafur Ingi Skúlason,Iceland,Kardemir Karabükspor
    339,Aron Gunnarsson (captain),Iceland,Cardiff City
    340,Hörður Björgvin Magnússon,Iceland,Bristol City
    341,Rúrik Gíslason,Iceland,SV Sandhausen
    342,Emil Hallfreðsson,Iceland,Udinese
    343,Arnór Ingvi Traustason,Iceland,Malmö
    344,Jón Daði Böðvarsson,Iceland,Reading
    345,Ari Freyr Skúlason,Iceland,Lokeren
    346,Ikechukwu Ezenwa,Nigeria,Enyimba
    347,Brian Idowu,Nigeria,Amkar Perm
    348,Elderson Echiéjilé,Nigeria,Cercle Brugge
    349,Wilfred Ndidi,Nigeria,Leicester City
    350,William Troost-Ekong,Nigeria,Bursaspor
    351,Leon Balogun,Nigeria,Mainz 05
    352,Ahmed Musa,Nigeria,CSKA Moscow
    353,Oghenekaro Etebo,Nigeria,Las Palmas
    354,Odion Ighalo,Nigeria,Changchun Yatai
    355,John Obi Mikel (captain),Nigeria,Tianjin TEDA
    356,Victor Moses,Nigeria,Chelsea
    357,Shehu Abdullahi,Nigeria,Bursaspor
    358,Simeon Nwankwo,Nigeria,Crotone
    359,Kelechi Iheanacho,Nigeria,Leicester City
    360,Joel Obi,Nigeria,Torino
    361,Daniel Akpeyi,Nigeria,Chippa United
    362,Ogenyi Onazi,Nigeria,Trabzonspor
    363,Alex Iwobi,Nigeria,Arsenal
    364,John Ogu,Nigeria,Hapoel Be'er Sheva
    365,Chidozie Awaziem,Nigeria,Nantes
    366,Tyronne Ebuehi,Nigeria,ADO Den Haag
    367,Kenneth Omeruo,Nigeria,Kasımpaşa
    368,Francis Uzoho,Nigeria,Deportivo La Coruña
    369,Alisson,Brazil,Roma
    370,Thiago Silva,Brazil,Paris Saint-Germain
    371,Miranda,Brazil,Inter Milan
    372,Pedro Geromel,Brazil,Grêmio
    373,Casemiro,Brazil,Real Madrid
    374,Filipe Luís,Brazil,Atlético Madrid
    375,Douglas Costa,Brazil,Juventus
    376,Renato Augusto,Brazil,Beijing Sinobo Guoan
    377,Gabriel Jesus,Brazil,Manchester City
    378,Neymar (captain),Brazil,Paris Saint-Germain
    379,Philippe Coutinho,Brazil,Barcelona
    380,Marcelo,Brazil,Real Madrid
    381,Marquinhos,Brazil,Paris Saint-Germain
    382,Danilo,Brazil,Manchester City
    383,Paulinho,Brazil,Barcelona
    384,Cássio,Brazil,Corinthians
    385,Fernandinho,Brazil,Manchester City
    386,Fred,Brazil,Shakhtar Donetsk
    387,Willian,Brazil,Chelsea
    388,Roberto Firmino,Brazil,Liverpool
    389,Taison,Brazil,Shakhtar Donetsk
    390,Fagner,Brazil,Corinthians
    391,Ederson,Brazil,Manchester City
    392,Keylor Navas,Costa Rica,Real Madrid
    393,Johnny Acosta,Costa Rica,Águilas Doradas
    394,Giancarlo González,Costa Rica,Bologna
    395,Ian Smith,Costa Rica,Norrköping
    396,Celso Borges,Costa Rica,Deportivo La Coruña
    397,Óscar Duarte,Costa Rica,Espanyol
    398,Christian Bolaños,Costa Rica,Saprissa
    399,Bryan Oviedo,Costa Rica,Sunderland
    400,Daniel Colindres,Costa Rica,Saprissa
    401,Bryan Ruiz (captain),Costa Rica,Sporting CP
    402,Johan Venegas,Costa Rica,Saprissa
    403,Joel Campbell,Costa Rica,Real Betis
    404,Rodney Wallace,Costa Rica,New York City FC
    405,Randall Azofeifa,Costa Rica,Herediano
    406,Francisco Calvo,Costa Rica,Minnesota United
    407,Cristian Gamboa,Costa Rica,Celtic
    408,Yeltsin Tejeda,Costa Rica,Lausanne
    409,Patrick Pemberton,Costa Rica,Alajuelense
    410,Kendall Waston,Costa Rica,Vancouver Whitecaps FC
    411,David Guzmán,Costa Rica,Portland Timbers
    412,Marco Ureña,Costa Rica,Los Angeles FC
    413,Rónald Matarrita,Costa Rica,New York City FC
    414,Leonel Moreira,Costa Rica,Herediano
    415,Vladimir Stojković,Serbia,Partizan
    416,Antonio Rukavina,Serbia,Villarreal
    417,Duško Tošić,Serbia,Beşiktaş
    418,Luka Milivojević,Serbia,Crystal Palace
    419,Uroš Spajić,Serbia,Anderlecht
    420,Branislav Ivanović,Serbia,Zenit Saint Petersburg
    421,Andrija Živković,Serbia,Benfica
    422,Aleksandar Prijović,Serbia,PAOK
    423,Aleksandar Mitrović,Serbia,Fulham
    424,Dušan Tadić,Serbia,Southampton
    425,Aleksandar Kolarov (captain),Serbia,Roma
    426,Predrag Rajković,Serbia,Maccabi Tel Aviv
    427,Miloš Veljković,Serbia,Werder Bremen
    428,Milan Rodić,Serbia,Red Star Belgrade
    429,Nikola Milenković,Serbia,Fiorentina
    430,Marko Grujić,Serbia,Cardiff City
    431,Filip Kostić,Serbia,Hamburger SV
    432,Nemanja Radonjić,Serbia,Red Star Belgrade
    433,Luka Jović,Serbia,Eintracht Frankfurt
    434,Sergej Milinković-Savić,Serbia,Lazio
    435,Nemanja Matić,Serbia,Manchester United
    436,Adem Ljajić,Serbia,Torino
    437,Marko Dmitrović,Serbia,Eibar
    438,Yann Sommer,Switzerland,Borussia Mönchengladbach
    439,Stephan Lichtsteiner (captain),Switzerland,Juventus
    440,François Moubandje,Switzerland,Toulouse
    441,Nico Elvedi,Switzerland,Borussia Mönchengladbach
    442,Manuel Akanji,Switzerland,Borussia Dortmund
    443,Michael Lang,Switzerland,Basel
    444,Breel Embolo,Switzerland,Schalke 04
    445,Remo Freuler,Switzerland,Atalanta
    446,Haris Seferović,Switzerland,Benfica
    447,Granit Xhaka,Switzerland,Arsenal
    448,Valon Behrami,Switzerland,Udinese
    449,Yvon Mvogo,Switzerland,RB Leipzig
    450,Ricardo Rodríguez,Switzerland,Milan
    451,Steven Zuber,Switzerland,1899 Hoffenheim
    452,Blerim Džemaili,Switzerland,Bologna
    453,Gelson Fernandes,Switzerland,Eintracht Frankfurt
    454,Denis Zakaria,Switzerland,Borussia Mönchengladbach
    455,Mario Gavranović,Switzerland,Dinamo Zagreb
    456,Josip Drmić,Switzerland,Borussia Mönchengladbach
    457,Johan Djourou,Switzerland,Antalyaspor
    458,Roman Bürki,Switzerland,Borussia Dortmund
    459,Fabian Schär,Switzerland,Deportivo La Coruña
    460,Xherdan Shaqiri,Switzerland,Stoke City
    461,Manuel Neuer (captain),Germany,Bayern Munich
    462,Marvin Plattenhardt,Germany,Hertha BSC
    463,Jonas Hector,Germany,1. FC Köln
    464,Matthias Ginter,Germany,Borussia Mönchengladbach
    465,Mats Hummels,Germany,Bayern Munich
    466,Sami Khedira,Germany,Juventus
    467,Julian Draxler,Germany,Paris Saint-Germain
    468,Toni Kroos,Germany,Real Madrid
    469,Timo Werner,Germany,RB Leipzig
    470,Mesut Özil,Germany,Arsenal
    471,Marco Reus,Germany,Borussia Dortmund
    472,Kevin Trapp,Germany,Paris Saint-Germain
    473,Thomas Müller,Germany,Bayern Munich
    474,Leon Goretzka,Germany,Schalke 04
    475,Niklas Süle,Germany,Bayern Munich
    476,Antonio Rüdiger,Germany,Chelsea
    477,Jérôme Boateng,Germany,Bayern Munich
    478,Joshua Kimmich,Germany,Bayern Munich
    479,Sebastian Rudy,Germany,Bayern Munich
    480,Julian Brandt,Germany,Bayer Leverkusen
    481,İlkay Gündoğan,Germany,Manchester City
    482,Marc-André ter Stegen,Germany,Barcelona
    483,Mario Gómez,Germany,VfB Stuttgart
    484,José de Jesús Corona,Mexico,Cruz Azul
    485,Hugo Ayala,Mexico,UANL
    486,Carlos Salcedo,Mexico,Eintracht Frankfurt
    487,Rafael Márquez,Mexico,Atlas
    488,Érick Gutiérrez,Mexico,Pachuca
    489,Jonathan dos Santos,Mexico,LA Galaxy
    490,Miguel Layún,Mexico,Sevilla
    491,Marco Fabián,Mexico,Eintracht Frankfurt
    492,Raúl Jiménez,Mexico,Benfica
    493,Giovani dos Santos,Mexico,LA Galaxy
    494,Carlos Vela,Mexico,Los Angeles FC
    495,Alfredo Talavera,Mexico,Toluca
    496,Guillermo Ochoa,Mexico,Standard Liège
    497,Javier Hernández,Mexico,West Ham United
    498,Héctor Moreno,Mexico,Real Sociedad
    499,Héctor Herrera,Mexico,Porto
    500,Jesús Manuel Corona,Mexico,Porto
    501,Andrés Guardado (captain),Mexico,Real Betis
    502,Oribe Peralta,Mexico,América
    503,Javier Aquino,Mexico,UANL
    504,Edson Álvarez,Mexico,América
    505,Hirving Lozano,Mexico,PSV Eindhoven
    506,Jesús Gallardo,Mexico,UNAM
    507,Kim Seung-gyu,South Korea,Vissel Kobe
    508,Lee Yong,South Korea,Jeonbuk Hyundai Motors
    509,Jung Seung-hyun,South Korea,Sagan Tosu
    510,Oh Ban-suk,South Korea,Jeju United
    511,Yun Young-sun,South Korea,Seongnam FC
    512,Park Joo-ho,South Korea,Ulsan Hyundai
    513,Son Heung-min,South Korea,Tottenham Hotspur
    514,Ju Se-jong,South Korea,Asan Mugunghwa
    515,Kim Shin-wook,South Korea,Jeonbuk Hyundai Motors
    516,Lee Seung-woo,South Korea,Hellas Verona
    517,Hwang Hee-chan,South Korea,Red Bull Salzburg
    518,Kim Min-woo,South Korea,Sangju Sangmu
    519,Koo Ja-cheol,South Korea,FC Augsburg
    520,Hong Chul,South Korea,Sangju Sangmu
    521,Jung Woo-young,South Korea,Vissel Kobe
    522,Ki Sung-yueng (captain),South Korea,Swansea City
    523,Lee Jae-sung,South Korea,Jeonbuk Hyundai Motors
    524,Moon Seon-min,South Korea,Incheon United
    525,Kim Young-gwon,South Korea,Guangzhou Evergrande
    526,Jang Hyun-soo,South Korea,FC Tokyo
    527,Kim Jin-hyeon,South Korea,Cerezo Osaka
    528,Go Yo-han,South Korea,FC Seoul
    529,Cho Hyun-woo,South Korea,Daegu FC
    530,Robin Olsen,Sweden,Copenhagen
    531,Mikael Lustig,Sweden,Celtic
    532,Victor Lindelöf,Sweden,Manchester United
    533,Andreas Granqvist (captain),Sweden,Krasnodar
    534,Martin Olsson,Sweden,Swansea City
    535,Ludwig Augustinsson,Sweden,Werder Bremen
    536,Sebastian Larsson,Sweden,Hull City
    537,Albin Ekdal,Sweden,Hamburger SV
    538,Marcus Berg,Sweden,Al Ain
    539,Emil Forsberg,Sweden,RB Leipzig
    540,John Guidetti,Sweden,Alavés
    541,Karl-Johan Johnsson,Sweden,Guingamp
    542,Gustav Svensson,Sweden,Seattle Sounders FC
    543,Filip Helander,Sweden,Bologna
    544,Oscar Hiljemark,Sweden,Genoa
    545,Emil Krafth,Sweden,Bologna
    546,Viktor Claesson,Sweden,Krasnodar
    547,Pontus Jansson,Sweden,Leeds United
    548,Marcus Rohdén,Sweden,Crotone
    549,Ola Toivonen,Sweden,Toulouse
    550,Jimmy Durmaz,Sweden,Toulouse
    551,Isaac Kiese Thelin,Sweden,Waasland-Beveren
    552,Kristoffer Nordfeldt,Sweden,Swansea City
    553,Thibaut Courtois,Belgium,Chelsea
    554,Toby Alderweireld,Belgium,Tottenham Hotspur
    555,Thomas Vermaelen,Belgium,Barcelona
    556,Vincent Kompany,Belgium,Manchester City
    557,Jan Vertonghen,Belgium,Tottenham Hotspur
    558,Axel Witsel,Belgium,Tianjin Quanjian
    559,Kevin De Bruyne,Belgium,Manchester City
    560,Marouane Fellaini,Belgium,Manchester United
    561,Romelu Lukaku,Belgium,Manchester United
    562,Eden Hazard (captain),Belgium,Chelsea
    563,Yannick Carrasco,Belgium,Dalian Yifang
    564,Simon Mignolet,Belgium,Liverpool
    565,Koen Casteels,Belgium,VfL Wolfsburg
    566,Dries Mertens,Belgium,Napoli
    567,Thomas Meunier,Belgium,Paris Saint-Germain
    568,Thorgan Hazard,Belgium,Borussia Mönchengladbach
    569,Youri Tielemans,Belgium,Monaco
    570,Adnan Januzaj,Belgium,Real Sociedad
    571,Mousa Dembélé,Belgium,Tottenham Hotspur
    572,Dedryck Boyata,Belgium,Celtic
    573,Michy Batshuayi,Belgium,Borussia Dortmund
    574,Nacer Chadli,Belgium,West Bromwich Albion
    575,Leander Dendoncker,Belgium,Anderlecht
    576,Jordan Pickford,England,Everton
    577,Kyle Walker,England,Manchester City
    578,Danny Rose,England,Tottenham Hotspur
    579,Eric Dier,England,Tottenham Hotspur
    580,John Stones,England,Manchester City
    581,Harry Maguire,England,Leicester City
    582,Jesse Lingard,England,Manchester United
    583,Jordan Henderson,England,Liverpool
    584,Harry Kane (captain),England,Tottenham Hotspur
    585,Raheem Sterling,England,Manchester City
    586,Jamie Vardy,England,Leicester City
    587,Kieran Trippier,England,Tottenham Hotspur
    588,Jack Butland,England,Stoke City
    589,Danny Welbeck,England,Arsenal
    590,Gary Cahill,England,Chelsea
    591,Phil Jones,England,Manchester United
    592,Fabian Delph,England,Manchester City
    593,Ashley Young,England,Manchester United
    594,Marcus Rashford,England,Manchester United
    595,Dele Alli,England,Tottenham Hotspur
    596,Ruben Loftus-Cheek,England,Crystal Palace
    597,Trent Alexander-Arnold,England,Liverpool
    598,Nick Pope,England,Burnley
    599,Jaime Penedo,Panama,Dinamo București
    600,Michael Amir Murillo,Panama,New York Red Bulls
    601,Harold Cummings,Panama,San Jose Earthquakes
    602,Fidel Escobar,Panama,New York Red Bulls
    603,Román Torres,Panama,Seattle Sounders FC
    604,Gabriel Gómez,Panama,Atlético Bucaramanga
    605,Blas Pérez,Panama,Municipal
    606,Édgar Bárcenas,Panama,Tapachula
    607,Gabriel Torres,Panama,Huachipato
    608,Ismael Díaz,Panama,Deportivo Fabril
    609,Armando Cooper,Panama,Universidad de Chile
    610,José Calderón,Panama,Chorrillo
    611,Adolfo Machado,Panama,Houston Dynamo
    612,Valentín Pimentel,Panama,Plaza Amador
    613,Erick Davis,Panama,Dunajská Streda
    614,Abdiel Arroyo,Panama,Alajuelense
    615,Luis Ovalle,Panama,CD Olimpia
    616,Luis Tejada,Panama,Sport Boys
    617,Ricardo Ávila,Panama,Gent
    618,Aníbal Godoy,Panama,San Jose Earthquakes
    619,José Luis Rodríguez,Panama,Gent
    620,Álex Rodríguez,Panama,San Francisco
    621,Felipe Baloy (captain),Panama,Municipal
    622,Farouk Ben Mustapha,Tunisia,Al-Shabab
    623,Syam Ben Youssef,Tunisia,Kasımpaşa
    624,Yohan Benalouane,Tunisia,Leicester City
    625,Yassine Meriah,Tunisia,CS Sfaxien
    626,Oussama Haddadi,Tunisia,Dijon
    627,Rami Bedoui,Tunisia,Étoile du Sahel
    628,Saîf-Eddine Khaoui,Tunisia,Troyes
    629,Fakhreddine Ben Youssef,Tunisia,Al-Ettifaq
    630,Anice Badri,Tunisia,Espérance
    631,Wahbi Khazri,Tunisia,Rennes
    632,Dylan Bronn,Tunisia,Gent
    633,Ali Maâloul,Tunisia,Al Ahly
    634,Ferjani Sassi,Tunisia,Al-Nassr
    635,Mohamed Amine Ben Amor,Tunisia,Al-Ahli
    636,Ahmed Khalil,Tunisia,Club Africain
    637,Aymen Mathlouthi (captain),Tunisia,Al-Batin
    638,Ellyes Skhiri,Tunisia,Montpellier
    639,Bassem Srarfi,Tunisia,Nice
    640,Saber Khalifa,Tunisia,Club Africain
    641,Ghailene Chaalali,Tunisia,Espérance
    642,Hamdi Nagguez,Tunisia,Zamalek
    643,Mouez Hassen,Tunisia,Châteauroux
    644,Naïm Sliti,Tunisia,Dijon
    645,David Ospina,Colombia,Arsenal
    646,Cristián Zapata,Colombia,Milan
    647,Óscar Murillo,Colombia,Pachuca
    648,Santiago Arias,Colombia,PSV Eindhoven
    649,Wílmar Barrios,Colombia,Boca Juniors
    650,Carlos Sánchez,Colombia,Espanyol
    651,Carlos Bacca,Colombia,Villarreal
    652,Abel Aguilar,Colombia,Deportivo Cali
    653,Radamel Falcao (captain),Colombia,Monaco
    654,James Rodríguez,Colombia,Bayern Munich
    655,Juan Cuadrado,Colombia,Juventus
    656,Camilo Vargas,Colombia,Deportivo Cali
    657,Yerry Mina,Colombia,Barcelona
    658,Luis Muriel,Colombia,Sevilla
    659,Mateus Uribe,Colombia,América
    660,Jefferson Lerma,Colombia,Levante
    661,Johan Mojica,Colombia,Girona
    662,Farid Díaz,Colombia,Olimpia
    663,Miguel Borja,Colombia,Palmeiras
    664,Juan Fernando Quintero,Colombia,River Plate
    665,José Izquierdo,Colombia,Brighton & Hove Albion
    666,José Fernando Cuadrado,Colombia,Once Caldas
    667,Dávinson Sánchez,Colombia,Tottenham Hotspur
    668,Eiji Kawashima,Japan,Metz
    669,Naomichi Ueda,Japan,Kashima Antlers
    670,Gen Shoji,Japan,Kashima Antlers
    671,Keisuke Honda,Japan,Pachuca
    672,Yuto Nagatomo,Japan,Galatasaray
    673,Wataru Endo,Japan,Urawa Red Diamonds
    674,Gaku Shibasaki,Japan,Getafe
    675,Genki Haraguchi,Japan,Fortuna Düsseldorf
    676,Shinji Okazaki,Japan,Leicester City
    677,Shinji Kagawa,Japan,Borussia Dortmund
    678,Takashi Usami,Japan,Fortuna Düsseldorf
    679,Masaaki Higashiguchi,Japan,Gamba Osaka
    680,Yoshinori Muto,Japan,Mainz 05
    681,Takashi Inui,Japan,Eibar
    682,Yuya Osako,Japan,1. FC Köln
    683,Hotaru Yamaguchi,Japan,Cerezo Osaka
    684,Makoto Hasebe (captain),Japan,Eintracht Frankfurt
    685,Ryota Oshima,Japan,Kawasaki Frontale
    686,Hiroki Sakai,Japan,Marseille
    687,Tomoaki Makino,Japan,Urawa Red Diamonds
    688,Gōtoku Sakai,Japan,Hamburger SV
    689,Maya Yoshida,Japan,Southampton
    690,Kosuke Nakamura,Japan,Kashiwa Reysol
    691,Wojciech Szczęsny,Poland,Juventus
    692,Michał Pazdan,Poland,Legia Warsaw
    693,Artur Jędrzejczyk,Poland,Legia Warsaw
    694,Thiago Cionek,Poland,SPAL
    695,Jan Bednarek,Poland,Southampton
    696,Jacek Góralski,Poland,Ludogorets Razgrad
    697,Arkadiusz Milik,Poland,Napoli
    698,Karol Linetty,Poland,Sampdoria
    699,Robert Lewandowski (captain),Poland,Bayern Munich
    700,Grzegorz Krychowiak,Poland,West Bromwich Albion
    701,Kamil Grosicki,Poland,Hull City
    702,Bartosz Białkowski,Poland,Ipswich Town
    703,Maciej Rybus,Poland,Lokomotiv Moscow
    704,Łukasz Teodorczyk,Poland,Anderlecht
    705,Kamil Glik,Poland,Monaco
    706,Jakub Błaszczykowski,Poland,VfL Wolfsburg
    707,Sławomir Peszko,Poland,Lechia Gdańsk
    708,Bartosz Bereszyński,Poland,Sampdoria
    709,Piotr Zieliński,Poland,Napoli
    710,Łukasz Piszczek,Poland,Borussia Dortmund
    711,Rafał Kurzawa,Poland,Górnik Zabrze
    712,Łukasz Fabiański,Poland,Swansea City
    713,Dawid Kownacki,Poland,Sampdoria
    714,Abdoulaye Diallo,Senegal,Rennes
    715,Saliou Ciss,Senegal,Valenciennes
    716,Kalidou Koulibaly,Senegal,Napoli
    717,Kara Mbodji,Senegal,Anderlecht
    718,Idrissa Gueye,Senegal,Everton
    719,Salif Sané,Senegal,Hannover 96
    720,Moussa Sow,Senegal,Bursaspor
    721,Cheikhou Kouyaté (captain),Senegal,West Ham United
    722,Mame Biram Diouf,Senegal,Stoke City
    723,Sadio Mané,Senegal,Liverpool
    724,Cheikh N'Doye,Senegal,Birmingham City
    725,Youssouf Sabaly,Senegal,Bordeaux
    726,Alfred N'Diaye,Senegal,Wolverhampton Wanderers
    727,Moussa Konaté,Senegal,Amiens
    728,Diafra Sakho,Senegal,Rennes
    729,Khadim N'Diaye,Senegal,Horoya
    730,Badou Ndiaye,Senegal,Stoke City
    731,Ismaïla Sarr,Senegal,Rennes
    732,M'Baye Niang,Senegal,Torino
    733,Keita Baldé,Senegal,Monaco
    734,Lamine Gassama,Senegal,Alanyaspor
    735,Moussa Wagué,Senegal,Eupen
    736,Alfred Gomis,Senegal,SPAL
  4. PaulC91 revised this gist Jun 13, 2018. 1 changed file with 4 additions and 8 deletions.
    12 changes: 4 additions & 8 deletions wc_network.R
    Original file line number Diff line number Diff line change
    @@ -28,10 +28,6 @@ df <-
    df_network <-
    map_df(df$id, ~ {

    player <- filter(df, id == .x) %>%
    pull(Player) %>%
    unique()

    country <- filter(df, id == .x) %>%
    pull(Country) %>%
    unique()
    @@ -40,15 +36,15 @@ df_network <-
    pull(Club) %>%
    unique()

    country_players <- filter(df, Country == country, id != .x)
    country_teammates <- filter(df, Country == country, id != .x)

    club_players <- filter(df, Club == club, id != .x)
    club_teammates <- filter(df, Club == club, id != .x)

    bind_rows(country_players, club_players) %>%
    bind_rows(country_teammates, club_teammates) %>%
    rename(to = id) %>%
    mutate(from = .x) %>%
    distinct() %>%
    select(from, to, Player, Country, Club)
    select(from, to)

    })

  5. PaulC91 revised this gist Jun 13, 2018. 1 changed file with 42 additions and 5 deletions.
    47 changes: 42 additions & 5 deletions wc_network.R
    Original file line number Diff line number Diff line change
    @@ -17,8 +17,45 @@ teams <- c("Egypt", "Russia", "Saudi Arabia", "Uruguay",
    "Belgium", "England", "Panama", "Tunisia",
    "Colombia", "Japan", "Poland", "Senegal")

    df <- map_df(1:32, ~ {
    tables[[.x]] %>%
    mutate(Country = teams[.x]) %>%
    select(Player, Country, Club)
    })
    df <-
    map_df(1:32, ~ {
    tables[[.x]] %>%
    mutate(Country = teams[.x]) %>%
    select(Player, Country, Club)
    }) %>%
    rownames_to_column("id")

    df_network <-
    map_df(df$id, ~ {

    player <- filter(df, id == .x) %>%
    pull(Player) %>%
    unique()

    country <- filter(df, id == .x) %>%
    pull(Country) %>%
    unique()

    club <- filter(df, id == .x) %>%
    pull(Club) %>%
    unique()

    country_players <- filter(df, Country == country, id != .x)

    club_players <- filter(df, Club == club, id != .x)

    bind_rows(country_players, club_players) %>%
    rename(to = id) %>%
    mutate(from = .x) %>%
    distinct() %>%
    select(from, to, Player, Country, Club)

    })

    wc_graph <- as_tbl_graph(df_network) %>%
    left_join(df, by = c("name" = "id"))

    ggraph(wc_graph) +
    geom_edge_fan(alpha = .25) +
    geom_node_point(aes(colour = Country)) +
    theme_graph()
  6. PaulC91 created this gist Jun 13, 2018.
    24 changes: 24 additions & 0 deletions wc_network.R
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,24 @@
    library(rvest)
    library(tidyverse)
    library(tidygraph)
    library(ggraph)

    wc_squads <- html("https://en.wikipedia.org/wiki/2018_FIFA_World_Cup_squads")

    tables <- wc_squads %>%
    html_table()

    teams <- c("Egypt", "Russia", "Saudi Arabia", "Uruguay",
    "Iran", "Morocco", "Portugal", "Spain",
    "Australia", "Denmark", "France", "Peru",
    "Argentina", "Croatia", "Iceland", "Nigeria",
    "Brazil", "Costa Rica", "Serbia", "Switzerland",
    "Germany", "Mexico", "South Korea", "Sweden",
    "Belgium", "England", "Panama", "Tunisia",
    "Colombia", "Japan", "Poland", "Senegal")

    df <- map_df(1:32, ~ {
    tables[[.x]] %>%
    mutate(Country = teams[.x]) %>%
    select(Player, Country, Club)
    })