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.
Open to UM Faculty/Staff/Students
Note: Please bring your own laptop (any OS).
Thursday and Friday, November 29-30, 2018
8:30 AM Registration | 9:00 AM – 5:00 PM Course Hours, Both Days
UM Coral Gables campus
Day 1 College of Engineering, McArthur Engineering Annex, Room #MEA 202
Day 2 Richter Library Learning Commons Flexible Programming Space (1st Floor), Room #102-B