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!