This work is licensed under a Creative Commons Attribution 4.0 International License. (CC-BY)

This data set includes metrics tracking interactions at the UIC Library of the Health Science Chicago reference desk between 2006-2011. The data set was originally captured on paper and was digitized under the supervision of Abigail Goben and Rebecca Raszewski. Data were missing from June-December 2007. The data set was standardized using Open Refine (http://openrefine.org), which uses JSON. The exported JSON code tracking the data standardization process for the data set has also been uploaded. Initial data analysis was conducted in OpenRefine and Microsoft Excel 2010/2013.

Files: 
1) ReadMe.txt --this file 
2) UnprocessedFullArchivalDataSet.xlsx  -- the data as digitized by student employees
3) ProcessedFullDataSet.csv -- the standardized data set after processing in OpenRefine
4) JSONfromOpenRefineforDeskData.txt  --the code extracted from OpenRefine after standardizing the data

Contact Information: 
Abigail Goben - agoben@uic.edu
Rebecca Raszewski - raszewr1@uic.edu 

Columns: 
Date
Time
Who Asked the Question? [Patron Type]
What Type of Question Was It?  [Question Type]
Notes


Standardized Answers:

Patron Type:
UIC Student
UIC Faculty or Staff
Other [Includes alumni, other regional medical professionals, students from other institutions, members of the public, etc]

Question Type:
Technology Assistance [Assistance with computers, printers, or other electronic devices]
In-Depth Reference [Substantive database searches, literature review assistance, or extended time period of assistance >10 minutes]
Ready Reference [Short, factual question (e.g. Do we subscribe to x journal? Where can I find this book?)]
Directional [Building directions (e.g. Where is the bathroom?)]



Open Refine Standardization General Description: 

1) Deleted description rows (Student/Fac/etc; Reference, etc) 
2) Save file as a CSV file
3) Upload to Open Refine ---? CREATE Project , NOT IMPORT PROJECT
3) Parse Data as CSV 
4) Standards: 

	Technology Assistance
	In-Depth Reference
	Ready Reference
	Directional

	UIC Student
	UIC Faculty or Staff
	Other
--Choose column, edit cells, Cluster and Edit

5) Time stamp update
	Format: HH:MM

-- Use Text Facet option to clean up time stamps

6) Remove blank records
	Star --> All --> Facet by Star  --> True --> Edit Rows  --> Remove all matching Rows

7) Check for blank fields in any column 
  * If blank in type of question asked: Ready Reference
  * If blank in who asked question: Student
  * if blank in date: check records on either side for appropriate date
  * if blank in time: check records on either side for appropriate time 

8) Sort for blanks/errors on all fields 

Sorting will stack

Export