Got messy data? Open Refine is a powerful, free open-source software tool for cleaning and transforming data in a way that is easy to reproduce. If you have ever struggled to remember exactly how you modified your data in Excel, give Open Refine a try!

In this class we will cover the basics of:

• importing data
• faceting data to discover patterns
• clustering data (as in cases where NYC and New York City should be the same name)
• splitting data into multiple columns
• exporting clean data

Please bring your own laptop!