Friday 29 June 2012

Euro 2012 Final

So we're down to 2 teams, and I think it's hats off to the Spanish newspapers who predicted this after the match in the group stages.

Barcelona now contribute the most players, 7, all of whom play for Spain.  Juventus and Real Madrid come next with 6 each.  The only team guaranteed to have a player on the winning side is Manchester City.

Monday 25 June 2012

Semi Final Time

Thankfully there was only one game that went to penalties.  I know they're probably the least worst method, but that doesn't mean I have to like them.

Semi-final diagram -

It makes sense that Portugal and Spain are locked together, while Germany and Italy hang off the centre, given the number of Portuguese players that play in Spain, and how most of Germany and Italy's players play in the league of their home nation.  Real Madrid still contribute the most players (10).

If you view the diagram as communities, they are Italy, Spain, Germany, Portugal, Real Madrid and Athletico Madrid.  Why the last one I do not know.

Wednesday 20 June 2012

Quarter Finals Team Diagram

Having redone the national teams vs league teams diagram in light of the group stage results, it now looks like this




Obviously, it's less spread out because there are fewer teams in it to act as pulling factors.

Bayern Munich no longer contribute the most players, Real Madrid do, as all 11 of their players are still in, while 4 of Bayern Munich's players have been eliminated.

The divide between Greece, Germany and the Czech Republic and everyone else is still there, which is interesting, as Croatia, Russia and Ukraine are all out, and I thought it was the links to them that were pulling Greece, Germany and the Czech Republic up and out.  It's obviously not.

Interestingly, if you look at it using modularity as the partition, Chelsea becomes it's own group, alone amongst the other teams.

Friday 15 June 2012

Group C - Not the group of death so much as the group of unbearable sadness

Italy are doing that thing again. I have a horrible feeling that Ireland will somehow beat them and then Spain will lose to Croatia and Italy will be out. Why do you keep doing this?!

I'm sad that Ireland are out, yes, I know they were outsiders but ...

Starting to rewrangle the players vs clubs data ready for the quarters, and yes, removing Ireland has moved Russia up to near Croatia and the Czech Republic, proving my point, I think, that there is still a divide down the old Iron Curtain.

Interestingly, if you do the communities thing after removing Ireland, not only are Sweden and the Netherlands one lump, so are England and Spain.

Wednesday 13 June 2012

Euro Group Stage - After Game 1 for All Groups

It's been a much more interesting, and tighter, competition than I was expecting, especially with Denmark beating the Netherlands.  I think it's still awaiting that one match to really kick start it, unless that match was Italy vs Spain which I didn't get to see much of.

Once again, the team I care most about are the ones I am going to be seeing the least of, but I suppose it has it's advantages with regard to stress.  Also, I'm starting to think that Italy do better when I don't watch them, which I am aware is irrational.  There are those teams and players where I know I have no effect, like Saints, and then those players were I know I am a terrible omen, like Ivanisevic.  I didn't watch a single match of his live in 2001, which part of me regrets but most of me is going 'yes, but it helped him win'.  At least I know that Ivanisevic would appreciate my logic.

Friday 8 June 2012

Finalised diagram

Correct as of 7 pm last night.



The two withdrawals from the Croatian team, both of whom play for German clubs, have moved Croatia further out towards the Ukraine, which I think amplifies my point about there still being a divide down Europe in terms of where people play their club football.

Monday 4 June 2012

Given that they still seem to be having friendlies

And people keep getting injured (poor Ivica Olic this time), the update of the diagram will have to wait, especially as I think this one will change the shape of the diagram quite a bit.

I understand why they have friendlies (especially in the case of Roy Hogson, who has been thrown in the deep end with a vengeance), but I start to think they could be more trouble than they're worth.

Sunday 3 June 2012

I feel desperately sorry for Gary Cahill, and wish him well.  It also means that the updated graph will need updating.

Friday 1 June 2012

Euro2012 and Graphs


Inspired by @psychemedia  (http://f1datajunkie.blogspot.co.uk/), I wondered if it would be possible to show both which teams contributed the most players to Euro2012, and the connections between the various leagues the players are from.  To do this I used the gephi software.

It produced the following graph -

The data is as accurate as wikipedia can manage, so there may be a few players whose club allegiences are slightly arguable (a couple of players who are out of contract at the end of the season and there's a wiki-war over whether that end is counted from the end of the domestic season or the start of the transfer window) and was finished before news of Frank Lampard's injury came through.  I'll update it to reflect that this weekend.

The results have thrown up some interesting things:

1 - contrary to my expectations, it's Bayern Munich, not Real Madrid or Barcelona that contribute the most players (13 vs 11 and 8 respectively).  That isn't shown as well as might be hoped in the diagram, possibly because Real Madrid and Barcelona both mostly contribute to the Spanish team while Bayern Munich has non-German players representing their countries, thus pulling the team into a crowded area of the diagram.

2 - while I was expecting certain countries to group together somewhat (I've had Danish friends who ranted at me about their national coach's fondness for picking players that play in Holland over players that play at home), I'm interested about which countries don't go into the main bit as much.  These tend to be either countries where their players are drawn from teams from that country that have few foreign players representing their own countries (group A) or where they have lots of players playing in foreign leagues, but where the teams those players play for don't have other internationals in (group B) or a mixture of both factors (group C).

Group A includes Greece, Ukraine, Russia and Italy

Group B includes Poland, Denmark, Ireland

Group C includes Croatia, Czech Republic

Germany is an odd one out because most of their players play in Germany, but several players from other countries play in the Bundesliga.  Sweden is the opposite, where most of their players play abroad, but for clubs with lots of other national representatives.

3 - There are several countries where 2 or 3 teams make up most of their squad - Greece, Ukraine and Russia.

Amazingly, Spain isn't one of them, with Barcelona and Real Madrid only making up 12 out of the 23.  I don't know if this is a sign of the increased amount of money being offered to players to move away and I'm very tempted to see if the players are more dispersed now than they were.

4 - Related to the above, despite England being the only team whose players are all drawn from their own national league, England is in the middle of the the diagram because, with the exception of Greece and the Ukraine, every other country has at least one English-based player playing for them.

5 - If we temporarily ignore Russia, who are being pulled away from the point I'm making by Aiden McGeady and Pavel Pogrebnyak, there still seems to be some sort of dividing line down the middle of Europe, round about where the Iron Curtain went.  This is interest in light of some comments (http://www.independent.co.uk/sport/football/international/fa-mad-to-give-france-an-edge-by-ignoring-top-base-in-ukraine-7665766.html) made by Tomásš Hübschman of the Czech Republic and Shaktar Donetsk who was bemused by England's decision to have their headquarters in Poland despite most of their group matches being on the other side of the Ukraine.  He said he wasn't surprised though, because there was this belief that the further East you went the rougher it got, which, according to him, was utterly untrue, especially in the case of Donetsk.

The reason Russia is pulled so far by only three links from their players to non-Russian teams (and six links coming inwards) is because the rest bunch together increasing the power of those three links.

~~~~

I plan on doing this again as the tournament continues, removing the teams as they get knocked out.  I don't think there will be much change in the central, heavily inter-connected teams, but I think their relative positions might change.

Any comments and complaints gratefully accepted.