Marcotti-MLS

Marcotti-MLS is a data schema used to create football databases. These databases capture statistical data used to support football research activities unique to Major League Soccer (MLS). These statistical data include historical data such as the following:

• Complete biographic/demographic data of all players who participated in or were drafted by Major League Soccer.
• Base and supplemental salary data of all players offered a contract in Major League Soccer.
• Data on player entry paths into Major League Soccer, including drafts, allocations, and developmental, Homegrown, and Designated Player contracts.
• Tenure periods of players at Major League Soccer clubs, used to track in-season movements.
• Seasonal statistics of participating players, including minutes played, goals, assists, disciplinary records, and goalkeeper specific data.

The Marcotti-MLS data schema is made up of backend-independent SQLAlchemy objects.

Installation

Marcotti-MLS is written in Python and uses the SQLAlchemy package heavily.

While not required, virtualenv is strongly recommended and virtualenvwrapper is very convenient.

Installation instructions:

1. Setup a virtual environment, grab the latest Marcotti-MLS repo, and install it into the environment:

   $ cd /path/to/working/dir
   $ mkvirtualenv marcotti-mls
   (marcotti-mls) $ git clone git://github.com/soccermetrics/marcotti-mls.git
   (marcotti-mls) $ cd marcotti-mls
   (marcotti-mls) $ make install

2. Run the dbsetup command and answer the setup questions to create configuration and data loading scripts.

   (marcotti-mls) $ dbsetup
   #### Please answer the following questions to setup the folder ####
   Work folder (must exist): [.] /path/to/files
   Logging folder (must exist): [.] /path/to/logs
   Config file name: [local]
   Config class name: [LocalConfig]

   The command will produce three files in the working folder:

   • local.py: A user-defined database configuration file
   • logging.json: Default logging configuration file
   • loader.py: Data loading module

Data Models

Unlike other data models in the Marcotti family, Marcotti-MLS is a single schema because it is only relevant to club football (in this case, a single league). Marcotti-MLS does borrow common models from other Marcotti schema.

Documentation

The Marcotti-MLS wiki contains extensive user documentation of the package.

License

(c) 2015-2019 Soccermetrics Research, LLC. Created under MIT license. See LICENSE file for details.