Difference between revisions of "Data Preparation Procedures"
Jump to navigation
Jump to search
Line 9: | Line 9: | ||
# Creating an item page for a game: '''[[Indexing a Football Game]]''' | # Creating an item page for a game: '''[[Indexing a Football Game]]''' | ||
− | DATA PREPARATION PROCEDURES | + | |
− | + | == DATA PREPARATION PROCEDURES == | |
+ | |||
+ | Spreadsheet preparation procedures - downloading/acquiring and then preparing spreadsheets based on time period within which each game occurred | ||
+ | |||
+ | === Category 1 Games === | ||
+ | |||
+ | These | ||
+ | |||
## '''[[Preparing Spreadsheets for Games 2014 to Present]]''' (with wall clock data) | ## '''[[Preparing Spreadsheets for Games 2014 to Present]]''' (with wall clock data) | ||
## '''[[Preparing Spreadsheets for Games 2001 to 2013]]''' (no wall clock data) | ## '''[[Preparing Spreadsheets for Games 2001 to 2013]]''' (no wall clock data) |
Revision as of 14:40, 21 December 2018
This page provides information on data preparation for using QuickStatement.
Procedures vary based on the year that a game occurred.
IMPORTANT: Before creating an Item page, be to to search to be sure it doesn't already exist!
PRELIMINARY STEPS
- Make sure a season page exists for each team participating in the game: Indexing a Football Team Season
- Creating an item page for a game: Indexing a Football Game
DATA PREPARATION PROCEDURES
Spreadsheet preparation procedures - downloading/acquiring and then preparing spreadsheets based on time period within which each game occurred
Category 1 Games
These
- Preparing Spreadsheets for Games 2014 to Present (with wall clock data)
- Preparing Spreadsheets for Games 2001 to 2013 (no wall clock data)
- Preparing Spreadsheets for Transcribed Games (that is, games with transcribed play-by-play data sources)
- Preparing Spreadsheets for Historical Games (that is, games without play-by-play data sources)
- Drive data preparation and upload procedures
- Drive creation
- Drive data
- Play-by-play data preparation and upload procedures
- Play creation
- Play-by-play data
Data prep required for creating and populate each drive's item page using QuickStatements... two steps process:
- Create spreadsheet that will derive Q numbers for each drive and incorporating "instance of" statements: Drive Creation Procedure
- Create spreadsheet to populate data about each drive's (now) existing item page: Drive Data Preparation
- Play-by-play Data Preparation and Upload Procedures