sganapati / engsoccerdata Goto Github PK
View Code? Open in Web Editor NEWThis project forked from jalapic/engsoccerdata
All English soccer results 1888-2014
This project forked from jalapic/engsoccerdata
All English soccer results 1888-2014
#### TOP 4 TIER ENGLISH LEAGUE SOCCER GAMES 1888-2014 #### engsoccerdata ============= ### Compiled by James Curley July 2014 Free to use for non-commerical use. If you do use it on any publications, blogs, websites, etc. please note the source (i.e. me!) Also, if you do use it - I would love to see any analysis produced from it etc. Of course, I accept no responsibility for any error that may be contained herewithin. Note: as of Sep 28th 2014, I have completed double and triple checks of all the data and have fixed some errors (see data folder). # My plan is to convert these functions/data into a R package in the not too distant future - if you'd like to get involved and help out, please let me know. - Also, if you can see better ways of writing the R code, please let me know. Contact details: jc3181 AT columbia DOT edu # What this repository contains: # Datasets - engsoccerdata2.csv - Results of all top 4 tier soccer games in England 1888-2014 (updated Sep 28th 2014) - engsoccerteams.csv - file containing list of 142 teams plus whether they were in the top 4 divisions in 2013/4 # Functions - makingtables.r - some dplyr scripts to make league tables for each season - soccercode.r - using dplyr and ggplot2 to look at goal differentials per game per team - namecheck.r - function to look up if characters exist in a team name - games_between.r - returns all games ever played between two teams - games_between.summary.r - returns the summary of results between any two teams - alltimerecord.r - returns the all time record of any team in the league - goals_by_team.r - Return all instances of a team scoring n goals - score_most.r - returns the team who has been involved in the most games of each scoreline - score_team.all.r - Lists all matches that a team has played in that ended in a scoreline - score_team.r - List all occurrences of a specific scoreline for a specific team - scoreline_by_team.r - How often each team has a won,lost,drawn by a scoreline? - totalgoals_by_team.r - Return all instances of a team being involved in a game with n goals - n_offs.r - Will return the scorelines that have occurred n number of times - opponentfreq.r - Return how often a team has played each opponent - games_by_tier.r - computes number of games played by tier per team - seasons_by_tier.r - computes number of seasons spent per tier per team - opponents.r - number of unique opponents for all teams in total or by tier - bestwins.r - best wins for each team - worstlosses.r - worst losses for each team #What does engsoccerdata2.csv contain? all top 4 tier games ever played 1888-2014 - FL = Football League - PL = Premier League - 1888/9 - 1891/2 FL Division 1 - 1892/3 - 1914/5 FL Divisions 1 & 2 - 1919/20 FL Divisions 1 & 2 - 1920/21 FL Divisions 1, 2 & 3 - 1921/22- 1938/9 FL Divisions 1, 2, 3a North & 3b South - 1939 FL Divisions 1, 2, 3a North & 3b South (truncated season) - 1946/7 - 1957/8 FL Divisions 1, 2, 3a North & 3b South - 1958/9 - 1991/2 FL Divisions 1, 2, 3 & 4 - 1992/3 - 2004/5 PL, FL Divisions 1, 2 & 3 - 2004/5 - 2013/4 PL, FL Championship, FL Divisions 1 & 2 In the csv file, I've used divisions 1,2,3,3a,3b, 4 as the notation I've also used tier 1,2,3,4 - to refer to 3,3a & 3b all belonging to tier 3 # Dataset includes: teams that dropped out half way through a season: - 1919 Leeds City - 1931 Wigan Borough - 1961 Accrington Stanley - includes 1919 Port Vale who replaced Leeds City mid-season - includes: truncated 1938 season - from 1993-2014, includes date of game. - games before 1993 only have Season. - Season refers to the first year of that season e.g. 1952/3 would be "1952" Team Names used in the file are those that are currently used: e.g. Small Heath are Birmingham City, Ardwick are Manchester City, etc. The modern Accrington Stanley are 'Accrington' to distinguish from original Accrington Stanley and earlier Accrington FC # Important Note I cannot 100% guarantee the accuracy of every result. I have checked very thouroughly for mistakes etc., but as this dataset was collected from multiple sources, there is a chance for the odd error. - If you find an error, let me know and I will fix asap. Note: as of Sep 28th 2014, I have completed more checks and fixed some errors. # List of Sources - This was mainly put together through much web-scraping from wikipedia (code available on request) - https://github.com/footballcsv/en-england (post 1992 data including dates) - http://en.wikipedia.org/wiki/The_Football_League (everything else) - http://www.rsssf.com/engpaul/fla/ (source for most of wikipedia data) - http://www.espn.co.uk/football/ (1980s missing seasons) - http://www.statto.com - http://www.11v11.com
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.