OpenRefine January 2022 Review

Happy February! For this month, we decided to share the most relevant and helpful OpenRefine January 2022 releases, tutorials, videos, and academic publications with you. Read on to discover them!

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

Release

• OpenRefine v3.5.2 by wetneb

Tutorials and Videos

• English Tutorials:
• Data Cleaning Chinese Text with OpenRefine: Facet
• How to sanctions-check a spreadsheet using OpenRefine

• German Tutorial:
• Ein Protokoll für den Datenabgleich im Web am Beispiel von OpenRefine und der Gemeinsamen Normdatei (GND)

• English Videos:
• Wikibase lightning talks: data upload and extensions session (WikidataCon 2021 recording)
• Prepare the data: Cleaning with OpenRefine
• HTML : Extract a html tag that contains a string in openrefine?

• Spanish Videos:
• The YouTube channel datosgob released a series of OpenRefine tutorials:
• Preparación de datos en CSV utilizando OpenRefine: carga de CSV y creación de proyecto
• Preparación de datos en CSV utilizando OpenRefine: modificación de columnas usando funciones GREL
• Preparación de datos en CSV utilizando OpenRefine: enlazado de valores con fuentes externas
• Preparación de datos en CSV utilizando OpenRefine: generación valores para listas controladas SKOS

• French Video:
• OpenRefine, Lexèmes et SPARQL

Academic Publication

• Use of OpenRefine in: "Evaluating Publisher Open Access Agreements"