d0xical OP t1_ixm0phk wrote on November 24, 2022 at 1:39 PM

Reply to comment by bokilala in [OC] What leagues do players that make up the 2022 World Cup Squads play in? by d0xical

After further inspection the club database and player database were not using same name for given club. i.e "Newcastle" not equal to "Newcastle United" & "Sevilla" not equal to "Sevilla FC".

d0xical OP t1_ixlzwl8 wrote on November 24, 2022 at 1:31 PM

Reply to comment by Johnasen in [OC] What leagues do players that make up the 2022 World Cup Squads play in? by d0xical

Can only have made yesterdays 2-1 more painful.

d0xical OP t1_ixlzoni wrote on November 24, 2022 at 1:29 PM

Reply to comment by diego_sr in [OC] What leagues do players that make up the 2022 World Cup Squads play in? by d0xical

Hmmm, this is a good point. Must be error to do with Brighton I think, will check.

d0xical OP t1_ixlyvwa wrote on November 24, 2022 at 1:21 PM

Reply to comment by 11160704 in [OC] What leagues do players that make up the 2022 World Cup Squads play in? by d0xical

Maybe unsurprisingly only one English player doesn't come from the Premier league.

d0xical OP t1_ixlyrfc wrote on November 24, 2022 at 1:20 PM

Reply to [OC] What leagues do players that make up the 2022 World Cup Squads play in? by d0xical

Data: https://en.wikipedia.org/wiki/2022_FIFA_World_Cup_squads

Tools: Python with Pandas

Should note that all countries take the same number of players (26) to the World Cup but I've only used plotted players that come from the top 6 global leagues (debatable to include MLS I know).