Difference between revisions of "Data Preparation Procedures"

From Wikibase.slis.ua.edu
Jump to navigation Jump to search
Line 17: Line 17:
 
# Drive Data Preparation and Upload Procedures (when available)
 
# Drive Data Preparation and Upload Procedures (when available)
 
## Drive Creation Procedure
 
## Drive Creation Procedure
###  
+
### Drive spreadsheets for games occurring from 2014 to present: '''[[Preparing Drive Spreadsheets (2014 to Present)]]'''
 +
### Drive spreadsheets for games occurring from 2001 to 2013: '''[[Preparing Drive Spreadsheets (2001 to 2013)]]'''
 +
### Transcribed drive spreadsheets for games occurring prior to 2001: '''[[Preparing Drive Spreadsheets (Transcribed Games)]]'''
 +
### Drive Spreadsheets drawn from newspaper accounts of historical games: '''[[Preparing Drive Spreadsheets (Historical Games)]]'''
 +
 
 
## Drive Data Procedure
 
## Drive Data Procedure
  

Revision as of 03:46, 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

  1. Make sure a season page exists for each team participating in the game: Indexing a Football Team Season
  2. Creating an item page for a game: Indexing a Football Game

DATA PREPARATION PROCEDURES

  1. Initial spreadsheet preparation procedures - downloading/acquiring and then preparing spreadsheets based on time period within which each game occurred
    1. Preparing Spreadsheets (2014 to Present): For games occurring from 2014 to present
    2. Preparing Spreadsheets (2001 to 2013): For games occurring from 2001 to 2013
    3. Preparing Spreadsheets (Transcribed Games): For for games occurring prior to 2001 (transcribed spreadsheets)
    4. Preparing Spreadsheets (Historical Games): For historical games drawn from newspaper accounts (for games lacking extant play-by-play data)
  2. Drive Data Preparation and Upload Procedures (when available)
    1. Drive Creation Procedure
      1. Drive spreadsheets for games occurring from 2014 to present: Preparing Drive Spreadsheets (2014 to Present)
      2. Drive spreadsheets for games occurring from 2001 to 2013: Preparing Drive Spreadsheets (2001 to 2013)
      3. Transcribed drive spreadsheets for games occurring prior to 2001: Preparing Drive Spreadsheets (Transcribed Games)
      4. Drive Spreadsheets drawn from newspaper accounts of historical games: Preparing Drive Spreadsheets (Historical Games)
    1. Drive Data Procedure

Data prep required for creating and populate each drive's item page using QuickStatements... two steps process:

    1. Create spreadsheet that will derive Q numbers for each drive and incorporating "instance of" statements: Drive Creation Procedure
    2. Create spreadsheet to populate data about each drive's (now) existing item page: Drive Data Preparation
  1. Play-by-play Data Preparation and Upload Procedures