Resources for using OpenRefine: Difference between revisions

Jump to navigation Jump to search
no edit summary
No edit summary
Line 17: Line 17:
Download OpenRefine from https://openrefine.org.
Download OpenRefine from https://openrefine.org.


=Handy expressions=
=Basic tutorials=
 
See links below for our recommended tutorials on how to use OpenRefine. OpenRefine itself maintains a more comprehensive list of externally produced tutorials [https://github.com/OpenRefine/OpenRefine/wiki/External-Resources here], and searching on [https://www.youtube.com/results?search_query=openrefine YouTube] and [https://vimeo.com/search?q=openrefine Vimeo] will also lead to many relevant videos.
 
* Data Carpentry lessons: [https://data-lessons.github.io/OpenRefine-nhcdata-lesson/ OpenRefine for Natural History Collection Data] and [https://datacarpentry.org/OpenRefine-ecology-lesson/ Data Cleaning with OpenRefine for Ecologists]
* Library Carpentry lesson: [https://librarycarpentry.org/lc-open-refine/ OpenRefine]
* [http://bit.ly/BITW13_OpenRefine OpenRefine Walk-through], step-by-step orientation by Javier Otegui using natural history museum data as a subject
* [https://www.youtube.com/watch?v=wGVtycv3SS0 Clean Your Data: Getting Started with OpenRefine], a workshop recording produced by the  University of Idaho Library Digital Initiatives (2017-02-15)
* Handouts created for use during the 2019 VRA Annual Conference workshop, ''Clean, Transform and Enhance Your Data'': [https://docs.google.com/document/d/1Z863T411TKd1FnmKrbEAERCPHNzxj4enscjTe3OnfgM/edit?usp=sharing Download and Install OpenRefine] and [https://docs.google.com/document/d/1fH_kqo5QtrovLk63uRf4ixScMMy-jO5IikrCOeZl6JM/edit?usp=sharing Getting Started with OpenRefine]
* [https://www.youtube.com/watch?v=6DIsErw8noM Data Cleaning with OpenRefine], and online short seminar organized by the Harvard Library (2020-06-25)
 
=Scripting=


value+"yourtexthere"
value+"yourtexthere"
Line 41: Line 52:
=Join the community=
=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.  
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=
 
See links below for our recommended tutorials on how to use OpenRefine. OpenRefine itself maintains a more comprehensive list of externally produced tutorials [https://github.com/OpenRefine/OpenRefine/wiki/External-Resources here], and searching on [https://www.youtube.com/results?search_query=openrefine YouTube] and [https://vimeo.com/search?q=openrefine Vimeo] will also lead to many relevant videos.
 
* Data Carpentry lessons: [https://data-lessons.github.io/OpenRefine-nhcdata-lesson/ OpenRefine for Natural History Collection Data] and [https://datacarpentry.org/OpenRefine-ecology-lesson/ Data Cleaning with OpenRefine for Ecologists]
* Library Carpentry lesson: [https://librarycarpentry.org/lc-open-refine/ OpenRefine]
* [http://bit.ly/BITW13_OpenRefine OpenRefine Walk-through], step-by-step orientation by Javier Otegui using natural history museum data as a subject
* [https://www.youtube.com/watch?v=wGVtycv3SS0 Clean Your Data: Getting Started with OpenRefine], a workshop recording produced by the  University of Idaho Library Digital Initiatives (2017-02-15)
* Handouts created for use during the 2019 VRA Annual Conference workshop, ''Clean, Transform and Enhance Your Data'': [https://docs.google.com/document/d/1Z863T411TKd1FnmKrbEAERCPHNzxj4enscjTe3OnfgM/edit?usp=sharing Download and Install OpenRefine] and [https://docs.google.com/document/d/1fH_kqo5QtrovLk63uRf4ixScMMy-jO5IikrCOeZl6JM/edit?usp=sharing Getting Started with OpenRefine]
* [https://www.youtube.com/watch?v=6DIsErw8noM Data Cleaning with OpenRefine], and online short seminar organized by the Harvard Library (2020-06-25)
646

edits

Navigation menu