The mancityfans.net football forum

Has anyone else taken any interest in the City Analytics data?

I downloaded it a while ago and was amazed at the amount of info involved. Every action of every player in every game,for the whole of last season.
If anything, there is almost too much info to take it all in.

Up to now, I have only had the time to extract the City players' analysis from it and have just completed listing Joe Hart's stats. If anybody is interested, you can download the stats from the OS.

Will post some stuff/opinions/conclusions from it when I get chance.

Looks a little complicated John but will look forward to your findings.

It's something that i do have an interest in having a look at but i completely forgot they were releasing all that data publicly so thanks for reminding me.

Must have a look and see if i can make any sense of it.

I looked at downloading it but I got the impression you had to be some kind of anal-ist, sporticunt or unicunt to qualify for a download.

Is any old pisshead allowed to download it ?

Ted Hughes wrote:I looked at downloading it but I got the impression you had to be some kind of anal-ist, sporticunt or unicunt to qualify for a download.

Is any old pisshead allowed to download it ?

No, you're good.

I signed up and there is shhhhiiiiitttloads of data
I hope theyre not waiting for me to comment

I downloaded it but haven't had a chance to run it through some 'borrowed' tools from work.

Beefers,
It's not complicated, just that there is so bloody much info,it is almost overwhelming.

I have managed to extract the City players from it, now I am in the extremely slow process of separating each record into HOME/AWAY/TOTALS and then trying to create a simplified list as an individual player overview. Itis the sheer amount ofinfo that makes it so difficult and time consuming.

Ted,
City are trying to create an interactive community with these stats and ask you to let them know in what way you are working with them. They then plan to link individuals who are working in a similar way with them into interactive groups. City seem quite open to allow people in.
I take umbrage at being classed as ANY OLD PISSHEAD....I consider myself to be quite a special OLD PISSHEAD...Go for it Ted, they will prove a very useful tool to use in your analysis.

Alex,
My thoughts were similar mate. When they arrived it was "WTF". You just need to take from them what you want.

Can somebody help please.

I have created a simplified list of Joe Hart's stats in Microsoft excel. They are in four columns but when I try to post the list on here, the separation of the columns disappears.
Is there any easier way, other than retrawling through the complete list and adding spaces, which is simply too time consuming to do if I wish to cover every player at some point?

I have also tried to cut and paste the excel into WORD and then on here but the same thing happens.

Try the code display.

Code: Select all

1   2   3
4   5   6

I Just Blue Myself wrote:Try the code display.

Code: Select all

1   2   3
4   5   6

If that doesn't work, try first copying the text from Excel to the Notepad. That should make the text separated by tabs rather than being in table format. And then use the code display.

Thanks Gents,
I willtry the notepad method and could you please explain the code method. I haven't a clue about this but have seen similar posted on here in the past. Please PM me on how I can do that.
Thanks.

Because of the overwhelming amount of material in the analytics, finding time saving methods is crucial and could save hours of trawling through each individual piece of info. I have the Joe Hart stuff ready on excel to post.

john68 wrote:Thanks Gents,
I willtry the notepad method and could you please explain the code method. I haven't a clue about this but have seen similar posted on here in the past. Please PM me on how I can do that.
Thanks.

Because of the overwhelming amount of material in the analytics, finding time saving methods is crucial and could save hours of trawling through each individual piece of info. I have the Joe Hart stuff ready on excel to post.

Hi John

I too have subscribed to this, but still thinking of ways to make something meaningful. Nastasic Vs Lescott over the season should become more measurable as this seasons data gets released - as a topical example.

Anyway I posted regarding the highlighted part above just to inquire whether you were familiar with pivot tables within excel?

I`ve found it very easy to use once you get round the basics, and dread to think that you are going on a cell by cell basis when a couple of hours learning the basics could save you days & days of effort.

Apologies if this sounds insulting to your pc literacy skills :)

Johnny,
My pc literacy skills are quite basic, I've played around with excel for a while now and have never needed to try out some of the more complex stuff. I tend to hit a problem, scratch my arse for a while, experiment, then somehow find some way (usually convaluted) to sort it all out.

Is there any way to convert a vertical list (or group of) to horizontal and vice versa? That would help me enormously.
Also, despite the best advice of Noolie and He Just Blue Himself, having tried the code and notebook methods they suggest, The cloumns are still ill defined and I can't get them on here without having to go through them, spacing them individually.

Normally none of this was a problem but with the sheer amount of data, piddling through/time etc just ain't an option.

Thanks in advance

john68 wrote:Johnny,
My pc literacy skills are quite basic, I've played around with excel for a while now and have never needed to try out some of the more complex stuff. I tend to hit a problem, scratch my arse for a while, experiment, then somehow find some way (usually convaluted) to sort it all out.

Is there any way to convert a vertical list (or group of) to horizontal and vice versa? That would help me enormously.
Also, despite the best advice of Noolie and He Just Blue Himself, having tried the code and notebook methods they suggest, The cloumns are still ill defined and I can't get them on here without having to go through them, spacing them individually.

Normally none of this was a problem but with the sheer amount of data, piddling through/time etc just ain't an option.

Thanks in advance

Paste, Special,Transpose



the fourth icon along.Looks like 2 rubbers (sorry USA, erasers)

john68 wrote:Has anyone else taken any interest in the City Analytics data?

I downloaded it a while ago and was amazed at the amount of info involved. Every action of every player in every game,for the whole of last season.
If anything, there is almost too much info to take it all in.

Up to now, I have only had the time to extract the City players' analysis from it and have just completed listing Joe Hart's stats. If anybody is interested, you can download the stats from the OS.

Will post some stuff/opinions/conclusions from it when I get chance.

Analyze This you old, Oh you cannot see what I am doing can yer, oops sorry John.

John,

Can you publish your attempts to paste into here onto the thread.

I`ve just had a go to see using straight copy & paste and it shows like this which looks fine to me:


Date Player ID Player Surname Player Forename Team Team Id Opposition
2012-04-28 28566 Abou Diaby Vassiriki Arsenal 3 Stoke City
2011-11-26 28566 Abou Diaby Vassiriki Arsenal 3 Fulham
2012-03-03 28566 Abou Diaby Vassiriki Arsenal 3 Liverpool
2012-04-21 28566 Abou Diaby Vassiriki Arsenal 3 Chelsea

Waheeeeey. Life is a classroom. My version of excel not the same as yours but I have now understood how to transpose this stuff...Thanks.
Also didn't know I could freeze cells....But now I do.

The straight cut and paste is fine when the items in the columns are of reasonably equal length Johnny. The spacing allows the columns to remain reasonably true. They don't remain true when the columns are not of the same length.

Below, the stats for Joe Hart (showing actions, home/away/totals.

APPEARANCES DETAILS HOME AWAY TOTAL
Games Played 19 19 38
Minutes Played 1,710 1,710 3,420
DISTRIBUTION/PASSING RECORD
GK Successful Distribution 164 161 325
GK Unsuccessful Distribution 59 85 144
TOTAL 223 246 469
Successful Passes 316 302 618
Unsuccessful Passes 180 227 407
TOTAL PASSES 496 529 1025
DISTRIBUTION/PASSING ANALYSIS
Passes (Forward) 365 407 772
Passes (Left) 72 69 141
Passes (Right) 59 53 112
TOTAL 496 529 1025
Successful Long Balls 30 38 68
Unsuccessful Long Balls 95 112 207
TOTAL 125 150 275
Key Passes 1 1 2
Successful Passes (Excl Crosses/Corners) 152 141 293
Unsuccessful Passes (Excl Crosses/Corners) 121 142 263
Sucessfull Passes (Own Half) 117 99 216
Unsuccessful Passes (Own Half) 21 19 40
Successful Passes (Opps Half) 35 42 77
Unsuccessful Passes (Opps Half) 100 123 223
Successful Passes (Defensive 1/3) 91 75 166
Unsuccessful Passes (Defensive 1/3) 0 3 3
Successful Passes (Middle 1/3) 52 47 99
Unsuccessful Passes (Middle 1/3) 81 73 154
Successful Passes (Final 1/3) 9 19 28
Unsuccessful Passes (Final 1/3) 40 66 106
Successful (Short Passes) 88 81 169
Unsuccessful (Short Passes) 1 2 3
Successful (Long Passes) 64 60 124
Unsuccessful (Long Passes) 120 140 260
Total Clearances 10 21 31
DUELS
Arial Duels Won 1 0 1
Arial Duels Lost 0 0 0
Ground Duels Won 3 6 9
Ground Duels Lost 0 2 2
TOTAL DUELS WON 4 6 10
TOTAL DUELS LOST 0 2 2
TOTAL DUELS 4 8 12
GOALS
Goals Conceded (Inside The Box) 10 14 24
Goals Conceded (Outside The Box) 2 3 5
TOTAL GOALS CONCEDED 12 17 29
SAVES
Saves Made (From Inside The Box) 24 26 50
Saves Made (From Outside The Box) 20 27 47
Saves From Penalty 0 1 1
TOTAL SAVES 44 54 98
SAVES ANALYSIS
Catches 17 20 37
Punches 8 13 21
Drops 1 1 2
Crosses Not Claimed 3 0 3
Clean Sheets 11 6 17
FOULS
Total Fouls Conceded 0 1 1
Total Fouls won 2 6 8
Fouls Won In Danger Area 0 0 0
Fouls Won Not In danger Area 2 6 8
Penalties Conceded 0 1 1
MISC ITEMS
Touches 594 662 1256
Corners Conceded 12 12 24
Challenge Lost 0 1 1
Error Leading To A Goal 0 1 1
Error Leading To An Attempt 0 1 1
Shots On - Conceded 58 75 133
Shots On - Conceded (Inside The Box) 36 45 81
Shots On - Conceded (Outside The Box) 22 30 52
Big Chances Faced 16 30 46
Recoveries 175 175 350
Unsuccessful Ball Touch 0 1 1
Successful Ball Touches 0 0 0
Take-Ons Overrun 0 0 0
Compld 152 152 304

My problem is that I want to get the home, away, total columns in i straight vertical line to allow them to be read easily.

Hazy,
It's ok you youngsters taking the piss mate....with all your new fangled technology. Just press a button and "voila" orgasm....I bet your wrists are as weedy as fucl though. Old fashioned had some advantages....just ask Gillie.

john68 wrote:Waheeeeey. Life is a classroom. My version of excel not the same as yours but I have now understood how to transpose this stuff...Thanks.
Also didn't know I could freeze cells....But now I do.

The straight cut and paste is fine when the items in the columns are of reasonably equal length Johnny. The spacing allows the columns to remain reasonably true. They don't remain true when the columns are not of the same length.

Below, the stats for Joe Hart (showing actions, home/away/totals.

APPEARANCES DETAILS HOME AWAY TOTAL
Games Played 19 19 38
Minutes Played 1,710 1,710 3,420
DISTRIBUTION/PASSING RECORD
GK Successful Distribution 164 161 325
GK Unsuccessful Distribution 59 85 144
TOTAL 223 246 469
Successful Passes 316 302 618
Unsuccessful Passes 180 227 407
TOTAL PASSES 496 529 1025
DISTRIBUTION/PASSING ANALYSIS
Passes (Forward) 365 407 772
Passes (Left) 72 69 141
Passes (Right) 59 53 112
TOTAL 496 529 1025
Successful Long Balls 30 38 68
Unsuccessful Long Balls 95 112 207
TOTAL 125 150 275
Key Passes 1 1 2
Successful Passes (Excl Crosses/Corners) 152 141 293
Unsuccessful Passes (Excl Crosses/Corners) 121 142 263
Sucessfull Passes (Own Half) 117 99 216
Unsuccessful Passes (Own Half) 21 19 40
Successful Passes (Opps Half) 35 42 77
Unsuccessful Passes (Opps Half) 100 123 223
Successful Passes (Defensive 1/3) 91 75 166
Unsuccessful Passes (Defensive 1/3) 0 3 3
Successful Passes (Middle 1/3) 52 47 99
Unsuccessful Passes (Middle 1/3) 81 73 154
Successful Passes (Final 1/3) 9 19 28
Unsuccessful Passes (Final 1/3) 40 66 106
Successful (Short Passes) 88 81 169
Unsuccessful (Short Passes) 1 2 3
Successful (Long Passes) 64 60 124
Unsuccessful (Long Passes) 120 140 260
Total Clearances 10 21 31
DUELS
Arial Duels Won 1 0 1
Arial Duels Lost 0 0 0
Ground Duels Won 3 6 9
Ground Duels Lost 0 2 2
TOTAL DUELS WON 4 6 10
TOTAL DUELS LOST 0 2 2
TOTAL DUELS 4 8 12
GOALS
Goals Conceded (Inside The Box) 10 14 24
Goals Conceded (Outside The Box) 2 3 5
TOTAL GOALS CONCEDED 12 17 29
SAVES
Saves Made (From Inside The Box) 24 26 50
Saves Made (From Outside The Box) 20 27 47
Saves From Penalty 0 1 1
TOTAL SAVES 44 54 98
SAVES ANALYSIS
Catches 17 20 37
Punches 8 13 21
Drops 1 1 2
Crosses Not Claimed 3 0 3
Clean Sheets 11 6 17
FOULS
Total Fouls Conceded 0 1 1
Total Fouls won 2 6 8
Fouls Won In Danger Area 0 0 0
Fouls Won Not In danger Area 2 6 8
Penalties Conceded 0 1 1
MISC ITEMS
Touches 594 662 1256
Corners Conceded 12 12 24
Challenge Lost 0 1 1
Error Leading To A Goal 0 1 1
Error Leading To An Attempt 0 1 1
Shots On - Conceded 58 75 133
Shots On - Conceded (Inside The Box) 36 45 81
Shots On - Conceded (Outside The Box) 22 30 52
Big Chances Faced 16 30 46
Recoveries 175 175 350
Unsuccessful Ball Touch 0 1 1
Successful Ball Touches 0 0 0
Take-Ons Overrun 0 0 0
Compld 152 152 304

Thanks that's all clear now