welshboy06 wrote: ↑Sun Aug 13, 2017 9:45 am
Hi All,
I've decided to start collecting football data. Mainly because I have an interest in the sport and also because of a certain jonnyg throwing stats around in a very hard to read format.
The data is quite simple and was just scraped from HKJC.
The data is in json format, but you should be able to convert it to csv and import it to Excel. I chose json as it reduces data duplication, is structured and can be read reasonably well by the human eye. It also works really well with Python (Which I'm using to scrape and also analyse the data)
The data contains the following info.
League
Season
Game Date
Home Team
Away Team
And also Goals and Red cards (Player, Time and Team)
At the moment I've only gotten around to scraping the BPL seasons that have all goal data on hkjc (04-05 to 16-17) I may also add in corners, however that would be total for the game, not timings.
More Leagues and seasons will be coming soon, but I'm pretty busy with work etc atm.
The file is a .txt file stored in the below zip (Couldn't upload .txt directly) and is less than 2mb! So should be easy to read and manipulate on anyones setup.
Just to note: The data is all scraped from HKJC, so if there are any errors it would be down to the data they provided.
BPL.zip
Now for one of the main reasons I did this, @jonnyg Asked me a question in another thread...
when you say easy ?
how easy ?
Well the answer to that question is 3.5gls (Total goals / Total Games)
Since the 2011-2012 season, the amount of games where the Home team scored first and the First goal was scored On or Before the 8th minute...
Total Games: 84 Total Goals: 294 Average Goals: 3.5
Min Goals: 1
Max Goals: 9
Cheers,
Adam
the question was rather different
"can you tell me for example what is the average goal production since 2011-2012 in games where the home team in the PL opened the scoring on 8 minutes ?