Introduction
- OpenRefine is a powerful, free, and open source tool that can be used for data cleaning.
- OpenRefine will automatically track any steps allowing you to backtrack as needed and providing a record of all work done.
Working with OpenRefine
- OpenRefine can import a variety of file types.
- OpenRefine can be used to explore data using filters.
- Clustering in OpenRefine can help to identify different values that might mean the same thing.
- OpenRefine can transform the values of a column.
Filtering and Sorting with OpenRefine
- OpenRefine provides a way to sort and filter data without affecting the raw data.
Examining Numbers in OpenRefine
- OpenRefine also provides ways to to examine and clean numerical data.
Using scripts
- All changes are being tracked in OpenRefine, and this information can be used for scripts for future analyses or reproducing an analysis.
Exporting and Saving Data from OpenRefine
- Cleaned data, or selected data, can be exported from OpenRefine for use in other applications.
- Projects can be exported to files that contain the original data and all data cleaning steps you performed.
Other Resources in OpenRefine
- Other examples and resources online are good for learning more about OpenRefine.