646
edits
Resources for using OpenRefine: Difference between revisions
Jump to navigation
Jump to search
no edit summary
(Created page with "=Getting started= Download OpenRefine from https://openrefine.org/ =Tutorials= [https://bit.ly/3KrPR9x Data Carpentry: OpenRefine for Natural History Collection Data] [htt...") |
No edit summary |
||
| Line 1: | Line 1: | ||
[[File:OpenRefine logo color.png|400px|]] | |||
=Why use OpenRefine?= | |||
OpenRefine is an open-source tool for manipulating small or large datasets in numerous formats (CSV, JSON, XML, etc.). Because of its low barrier to entry with no prior programming knowledge needed, OpenRefine is an excellent tool to for the improvement and maintenance of data integrity for best practices in collections management. Data transformations are reversible and repeatable, and original data are locally preserved. The learning curve for OpenRefine is moderate, with a large community of users and shared knowledge base for help. You can use the resources on this wiki page as a starting point! | |||
==When to use OpenRefine== | |||
* For '''quality control''', e.g. to clean recent data entry prior to (or after) database ingestion, or to clean legacy data. | |||
* For '''combining and manipulating existing datasets''', e.g. to transform or integrate your data with external resources like those in a taxonomic authority or Wikidata. | |||
==When not to use OpenRefine== | |||
* For '''adding new records''' individually to an existing dataset, e.g. when transcribing specimen labels. | |||
* For '''text-heavy one-off data entry''', e.g. when typing a sentence in a notes field associated with each row. | |||
* For projects with '''multiple users on separate computers.''' | |||
=Getting started= | =Getting started= | ||
Download OpenRefine from https://openrefine.org/ | Download OpenRefine from https://openrefine.org. | ||
=Join the community= | |||
There are many audiences for OpenRefine, and the best community to join is one that aligns with your usage context and skill level. The [https://bit.ly/3kqiGIR OpenRefine Google Group] is maintained by OpenRefine, and most messages posted are more technical. | |||
=Tutorials= | =Tutorials= | ||
| Line 10: | Line 28: | ||
[https://bit.ly/39kKmfX Library Carpentry] | [https://bit.ly/39kKmfX Library Carpentry] | ||
[https://bit.ly/3wcBIYX YouTube] & [https://bit.ly/37RoiJz Vimeo] | [https://bit.ly/3wcBIYX YouTube] & [https://bit.ly/37RoiJz Vimeo] | ||