Preliminary Data Upload

  1. Download data from Baker and Taylor
  2. Add the following the columns to the data:
    1. resort: a boolean column that indicates whether the library is a resort library.
    2. metro: a boolean column that indicates whether library is part of metro report. [DO WE NEED THIS ANYMORE?]
    3. popu_lsa:  LSA population is obtained from [FEDS?]
    4. codename:  the old LRS unique identifier for each library. We now use fscskey for managing libraries, however, the challenge tool still uses codename.
  3. Set the values of columns in #2 to “-1” (-1, without the quotes).
    1. resort, metro, and codename will be populated based on previous year’s data.
    2. popu_lsa will be populated based on most recent IMLS data.
  4. Match questions to codes
    1. The B&T spreadsheet has question numbers as column headers, so we need to match them to IMLS/LRS variables.
    2. The survey usually doesn’t change much from year-to-year, so the best place to start is to copy over the question->variable matches from the previous year’s spreadsheet.
    3. Go through each question and ensure that the variable is correct.  Keep a paper copy!
    4. For new questions, create common sense variable names using ONLY letters and underscores.  E.g.
      1. Total number of coffee shops = coffee_shops
      2. Coffee shops per capita = coffee_shops_per_capita
  5. Upload data to Tool @ https://www.lrs.org/public/data/tools
Scroll to Top