I’ve done more than my fair share of data wrangling. Dealing with data entry errors, formatting mismatches and other messy data is frustrating and can take way more time than anyone can spare. Enter OpenRefine.
OpenRefine (formerly Google Refine) is a VERY USEFUL tool that makes working with messy data so much easier. What can it do with your messy data?
- Clean it
- Transform it from one format to another
- Extend it with web services and
- Link it to databases
If you do any work at all with data, this could save you TONS of time! I can’t do it justice with a description, so watch these videos below to see it in action:
Introduction to OpenRefine
Reconcile and Match Data