Registration Desk Open at AT&T Center, 200 level
SUN: 11am - 8pm | MON: 7am - 7pm | TUE: 7am - 6pm | WED: 7am - 1pm

All times list are in Central time (local Austin time zone)

Back To Schedule
Tuesday, March 5 • 1:30pm - 2:15pm
S54: Confronting the elephant in the room: Cleaning and Wrangling Data for Collections and Scholarly Services

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Have you attended a presentation in which data visualizations answered key questions for stakeholders? You plan to replicate it for your library, only to find that you are missing the intermediate steps of how to get the data into a usable state. This presentation will call the elephant out.

It is often stated that 80% of time in an analysis project is devoted to data cleaning. This is certainly a challenge for libraries as the data comes from so many different sources. It is the getting, cleaning, and transforming phase, which feeds into the visualization and modeling phase; yet, we often gloss over this part of our work. This presentation will break down the challenges of collecting and creating collections datasets and merging them together into interactive visualizations. This included gathering and cleaning data, fuzzy merging messy text strings, reshaping data from wide to long format, and making decisions on handling duplicate and missing values. The wrangling of data together into an interactive visualization with data filters adds immense value by enlarging the context of decision-making.

This presentation will discuss case studies demonstrating ways that data expertise has elevated our work with collections and in the creation and dissemination of scholarship. Discussing the challenges of data wrangling will make assessment feasible for librarians wanting to review their collections and projects. It will also serve as another call to data providers to provide clean, standardized, and interoperable data.


avatar for Shannon Burke

Shannon Burke

Coordinator of Monograph Acquisitions, Texas A&M University
I have experience in the areas of electronic resources, discovery, collection development, and acquisitions. I have a particular interest in interactive data visualization, using tools such as Tableau and the R programming language, to aid in evaluation and decision-making.
avatar for Clarke Iakovakis

Clarke Iakovakis

Scholarly Services Librarian, Oklahoma State University

Tuesday March 5, 2019 1:30pm - 2:15pm CST
Room 203