Cleaning Data with OpenRefine & Excel Workshop 11/29-30/2018 Gables Campus



Register Now

Open to UM Faculty/Staff/Students

This workshop introduces participants to techniques for cleaning and transforming data with OpenRefine and Microsoft Excel. Sometimes datasets are created by multiple individuals, and/or created without a clear set of guidelines. The resulting datasets may be difficult to analyze because they lack standardization (i.e., New York City may be listed as “NYC,” “New York, NY”, “New York City”, and “New York City, NY”). In this workshop, participants will learn how to quickly and efficiently find standardization issues and other errors, and how to correct them in bulk, as well as how to enhance existing datasets by adding new metadata fields.

OpenRefine logo

When

Thursday and Friday, November 29-30, 2018
8:30 AM Registration  | 9:00 AM – 5:00 PM Course Hours, Both Days

Where

UM Coral Gables campus

Day 1 College of Engineering, McArthur Engineering Annex, Room #MEA 202
Day 2 School of Communication, Communication International Building, Room #CIB 4051

 

Note: Please bring your own laptop (any OS).

 

 

Instructors:  Cameron Riopelle, PhD, Data Services Librarian  |  Paige Morgan PhD, Digital Scholarship Librarian and Scholarly Publishing Officer

 


SPONSORS

 


University of Miami Graduate School logo            University of Miami Center for Neuroscience and Aging logo 

University of Miami Richter Libraries logo                University of Miami Department of Public Health Sciences logo            University of Miami Center for Computational Science logo
 

CCS
Skip to toolbar