Using OpenRefine for cleaning up spreadsheet data
OpenRefine is a free tool for reviewing and cleaning up spreadsheet or tabular data. Save yourself a lot of time by using OpenRefine to identify and fix problems in your tabular data. Automated functions easily and quickly handle common problems, such as splitting cells that contain multiple data values, detecting duplicates and typos, standardizing date formats, and trimming extra spaces from cells. OpenRefine also keeps track of all your steps, so you can easily reuse them or undo them if necessary.
Feel Free to bring your own laptops and download the software before the class: https://github.com/OpenRefine/OpenRefine/wiki/Installation-Instructions
- Tuesday, April 16, 2019
- 2:30pm - 3:30pm
- Engineering Library - Creative Space