Difference between revisions of "Data Preparation Procedures"
Jump to navigation
Jump to search
Line 15: | Line 15: | ||
## '''[[Preparing Spreadsheets for Transcribed Games]]''' (with transcribed play-by-play data sources) | ## '''[[Preparing Spreadsheets for Transcribed Games]]''' (with transcribed play-by-play data sources) | ||
## '''[[Preparing Spreadsheets for Historical Games]]''' (without play-by-play data sources) | ## '''[[Preparing Spreadsheets for Historical Games]]''' (without play-by-play data sources) | ||
− | # Drive | + | # Drive data preparation and upload procedures |
## Drive Creation and Upload Procedures | ## Drive Creation and Upload Procedures | ||
### '''[[Preparing Drive Creation Spreadsheets for Games 2014 to Present]]''' | ### '''[[Preparing Drive Creation Spreadsheets for Games 2014 to Present]]''' | ||
Line 21: | Line 21: | ||
### '''[[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 | + | ## Drive data preparation and upload procedures |
### '''[[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]]''' | ||
### '''[[Preparing Drive Data Spreadsheets for Transcribed Games]]''' | ### '''[[Preparing Drive Data Spreadsheets for Transcribed Games]]''' | ||
### '''[[Preparing Drive Data Spreadsheets for Historical Games]]''' | ### '''[[Preparing Drive Data Spreadsheets for Historical Games]]''' | ||
− | # Play-by-play | + | # Play-by-play data preparation and upload procedures |
## Play Creation and Upload Procedures | ## Play Creation and Upload Procedures | ||
### '''[[Preparing Play Creation Spreadsheets for Games 2014 to Present]]''' | ### '''[[Preparing Play Creation Spreadsheets for Games 2014 to Present]]''' | ||
Line 32: | Line 32: | ||
### '''[[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-by-play data preparation and upload procedures |
### '''[[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:18, 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 and Upload Procedures
- Drive data preparation and upload procedures
- Play-by-play data preparation and upload procedures
- Play Creation and Upload Procedures
- Play-by-play data preparation and upload procedures
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