Difference between revisions of "Data Preparation Procedures"
Jump to navigation
Jump to search
Line 16: | Line 16: | ||
## '''[[Preparing Spreadsheets (Historical Games)]]''': For historical games drawn from newspaper accounts (for games lacking extant play-by-play data) | ## '''[[Preparing Spreadsheets (Historical Games)]]''': For historical games drawn from newspaper accounts (for games lacking extant play-by-play data) | ||
# Drive Data Preparation and Upload Procedures (when available) | # Drive Data Preparation and Upload Procedures (when available) | ||
− | ## Drive Creation | + | ## Drive Creation Procedures |
− | ### '''[[Preparing Drive Spreadsheets (2014 to Present)]]''' | + | ### '''[[Preparing Drive Creation Spreadsheets (2014 to Present)]]''' |
− | ### '''[[Preparing Drive Spreadsheets (2001 to 2013)]]''' | + | ### '''[[Preparing Drive Creation Spreadsheets (2001 to 2013)]]''' |
− | ### '''[[Preparing Drive Spreadsheets (Transcribed Games)]]''' | + | ### '''[[Preparing Drive Creation Spreadsheets (Transcribed Games)]]''' |
− | ### '''[[Preparing Drive Spreadsheets (Historical Games)]]''' | + | ### '''[[Preparing Drive Creation Spreadsheets (Historical Games)]]''' |
− | ## Drive Data | + | ## Drive Data Preparation Procedures |
− | ### '''[[Preparing Drive Spreadsheets (2014 to Present)]]''' | + | ### '''[[Preparing Drive Data Spreadsheets (2014 to Present)]]''' |
− | ### '''[[Preparing Drive Spreadsheets (2001 to 2013)]]''' | + | ### '''[[Preparing Drive Data Spreadsheets (2001 to 2013)]]''' |
− | ### '''[[Preparing Drive Spreadsheets (Transcribed Games)]]''' | + | ### '''[[Preparing Drive Data Spreadsheets (Transcribed Games)]]''' |
− | ### '''[[Preparing Drive Spreadsheets (Historical Games)]]''' | + | ### '''[[Preparing Drive Data Spreadsheets (Historical Games)]]''' |
− | + | # Play-by-play Data Preparation and Upload Procedures (when available) | |
+ | ## Play Creation Procedures | ||
+ | ### '''[[Preparing Play Creation Spreadsheets (2014 to Present)]]''' | ||
+ | ### '''[[Preparing Play Creation Spreadsheets (2001 to 2013)]]''' | ||
+ | ### '''[[Preparing Play Creation Spreadsheets (Transcribed Games)]]''' | ||
+ | ### '''[[Preparing Play Creation Spreadsheets (Historical Games)]]''' | ||
+ | ## Drive Data Preparation Procedures | ||
+ | ### '''[[Preparing Play-by-play Data Spreadsheets (2014 to Present)]]''' | ||
+ | ### '''[[Preparing Play-by-play Data Spreadsheets (2001 to 2013)]]''' | ||
+ | ### '''[[Preparing Play-by-play Data Spreadsheets (Transcribed Games)]]''' | ||
+ | ### '''[[Preparing Play-by-play Data Spreadsheets (Historical Games)]]''' | ||
Data prep required for creating and populate each drive's item page using QuickStatements... two steps process: | Data prep required for creating and populate each drive's item page using QuickStatements... two steps process: |
Revision as of 03:50, 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 (2014 to Present): For games occurring from 2014 to present
- Preparing Spreadsheets (2001 to 2013): For games occurring from 2001 to 2013
- Preparing Spreadsheets (Transcribed Games): For for games occurring prior to 2001 (transcribed spreadsheets)
- Preparing Spreadsheets (Historical Games): For historical games drawn from newspaper accounts (for games lacking extant play-by-play data)
- Drive Data Preparation and Upload Procedures (when available)
- Drive Creation Procedures
- Drive Data Preparation Procedures
- Play-by-play Data Preparation and Upload Procedures (when available)
- Play Creation Procedures
- Drive Data Preparation 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