OpenRefine December 2021 Review

Happy January! We wish you a very Happy New Year! For the first month of the year, we decided to share the most relevant and helpful OpenRefine December 2021 community announcements, releases, tutorials, videos, and academic publications with you.

Don't forget to subscribe to our newsletter to get our monthly updates right in your inbox!

Community Announcements

• Structured Data on Commons functionalities: welcome to OpenRefine's new team members!

• Join OpenRefine's Advisory Committee

Releases

• OpenRefine v3.5.1 by wetneb

• OpenRefine 4.0-alpha1 by wetneb

Tutorials and Videos

• English Tutorials:
• OpenRefine Tutorial on Using OpenRefine on FactGrid with Lucas Werkmeister
• Data Cleaning with OpenRefine
• From Disparate Data to Visualized Knowledge Part I: Moving from Spreadsheets to an RDF Database

• German Tutorials:
• Gemeinsam an OpenRefine-Projekten arbeiten
• OpenRefine by Kathi Woitas, Digital Scholarship Services, Universitätsbibliothek Bern

• English Videos:
• CU Digital Scholarship Workshops [Fall 2021]: Using OpenRefine for Cleaning Data
  
• Data Cleaning in OpenRefine (Library Skills Week 2021)
• String matching algorithms in OpenRefine clustering and reconciliation functions
• Introduction to OpenRefine: Using Open Software to Weed and Manage a Government Documents Collection
• Creating items on Wikidata using OpenRefine (without sound — subtitles only)

• Spanish Videos:
• Introducción a Open Refine
• LIMPIEZA DE DATOS DE BIODIVERSIDAD con OpenRefine: Funciones básicas
• LIMPIEZA DE DATOS DE BIODIVERSIDAD con OpenRefine: Funciones avanzadas

• French Video:
• De l'ocr vers Word pour OpenRefine: exemples de transformations

Academic Publications

• Use of OpenRefine in: "Reports of substandard medicines: a lexicographic analysis of the Brazilian Health Surveillance Report System"

• Use of OpenRefine in: "Developing a Comprehensive Faculty Bibliography to Facilitate Scholarly Communications Outreach"

• Use of OpenRefine in: "Mapping research on family business in tourism and hospitality: a bibliometric analysis"

• An example of an OpenRefine Reconciliation Service in Javascript

• or2yw: Modeling and Visualizing OpenRefineHistories as YesWorkflow Diagrams

• Use of OpenRefine in "Preparing for a Name Disambiguation Application for Institutional Repositories at Texas A&M University: the Planning and Test Preparation Phases" by the Texas A&M University Libraries