Difference between revisions of "Data Preparation Procedures"
Jump to navigation
Jump to search
Line 16: | Line 16: | ||
## '''[[Preparing Spreadsheets for Historical Games]]''' (without play-by-play data sources) | ## '''[[Preparing Spreadsheets for Historical Games]]''' (without play-by-play data sources) | ||
# Drive data preparation and upload procedures | # Drive data preparation and upload procedures | ||
− | ## Drive | + | ## Drive creation |
### '''[[Preparing Drive Creation Spreadsheets for Games 2014 to Present]]''' | ### '''[[Preparing Drive Creation Spreadsheets for Games 2014 to Present]]''' | ||
### '''[[Preparing Drive Creation Spreadsheets for Games 2001 to 2013]]''' | ### '''[[Preparing Drive Creation Spreadsheets for Games 2001 to 2013]]''' | ||
### '''[[Preparing Drive Creation Spreadsheets for Transcribed Games]]''' | ### '''[[Preparing Drive Creation Spreadsheets for Transcribed Games]]''' | ||
### '''[[Preparing Drive Creation Spreadsheets for Historical Games]]''' | ### '''[[Preparing Drive Creation Spreadsheets for Historical Games]]''' | ||
− | ## Drive data | + | ## Drive data |
### '''[[Preparing Drive Data Spreadsheets for Games 2014 to Present]]''' | ### '''[[Preparing Drive Data Spreadsheets for Games 2014 to Present]]''' | ||
### '''[[Preparing Drive Data Spreadsheets for Games 2001 to 2013]]''' | ### '''[[Preparing Drive Data Spreadsheets for Games 2001 to 2013]]''' | ||
Line 27: | Line 27: | ||
### '''[[Preparing Drive Data Spreadsheets for Historical Games]]''' | ### '''[[Preparing Drive Data Spreadsheets for Historical Games]]''' | ||
# Play-by-play data preparation and upload procedures | # Play-by-play data preparation and upload procedures | ||
− | ## Play | + | ## Play creation |
### '''[[Preparing Play Creation Spreadsheets for Games 2014 to Present]]''' | ### '''[[Preparing Play Creation Spreadsheets for Games 2014 to Present]]''' | ||
### '''[[Preparing Play Creation Spreadsheets for Games 2001 to 2013]]''' | ### '''[[Preparing Play Creation Spreadsheets for Games 2001 to 2013]]''' | ||
### '''[[Preparing Play Creation Spreadsheets for Transcribed Games]]''' | ### '''[[Preparing Play Creation Spreadsheets for Transcribed Games]]''' | ||
### '''[[Preparing Play Creation Spreadsheets for Historical Games]]''' | ### '''[[Preparing Play Creation Spreadsheets for Historical Games]]''' | ||
− | ## Play-by-play data | + | ## Play-by-play data |
### '''[[Preparing Play-by-play Data Spreadsheets for Games 2014 to Present]]''' | ### '''[[Preparing Play-by-play Data Spreadsheets for Games 2014 to Present]]''' | ||
### '''[[Preparing Play-by-play Data Spreadsheets for Games 2001 to 2013]]''' | ### '''[[Preparing Play-by-play Data Spreadsheets for Games 2001 to 2013]]''' |
Revision as of 04:19, 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
- Initial spreadsheet preparation procedures - downloading/acquiring and then preparing spreadsheets based on time period within which each game occurred
- Preparing Spreadsheets for Games 2014 to Present
- Preparing Spreadsheets for Games 2001 to 2013
- Preparing Spreadsheets for Transcribed Games (with transcribed play-by-play data sources)
- Preparing Spreadsheets for Historical 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