23965 shaares
75 results
tagged
openrefine
Add stuff to SNAC with OpenRefine.
So you have heard about some cool text analysis tools that identify word frequencies, generate word clouds, and look for trends and patterns? Can’t wait to try them out? Well, after uploading your …
I have long known about OpenRefine (previously Google Refine) which is a tool for working with data, manipulating and cleaning it. As of version 3.0 (May 2018), OpenRefine included a Wikidata extension, allowing for extra reconciliation and also editing of Wikidata directly (as far as I understand it). You can find some documentation on this […]
We’ve all been there – you get some data from a client or a survey you’ve run, and you can’t wait to start answering your evaluation questions. But you find one of your data columns is a complete mess because it was an open-ended text field. Cleaning this messy data can be a day-ruining task - but
This blogpost is by Graham Jevon, Cataloguer, Endangered Archives Programme Creating detailed and consistent metadata is a challenge common to most archives. Many rely on an army of volunteers with varying degrees of cataloguing experience. And no matter how diligent any team of cataloguers are, human error and individual idiosyncrasies...
We all know the pain of merging different columns in OpenRefine when you have null values. Before version 3.0, it required writing a co...
Information on downloading sample records from the Getty Vocabularies.
Remark: I wrote this post long time ago but never published it. Unfortunately BatchRefine is still on the old 2.x codebase of OpenRefine but some might still find it useful. In this post I will show how you can use a headless OpenRefine instance called BatchRefine to process large amounts of CSV data without memory problems. A normal OpenRefine instance is in our experience not really suited for processing large files. If you ever tried to load several hundred thousand or even millions of lines...
Includes data samples.
An extension to OpenRefine that enables graphical mapping of OpenRefine project data to an RDF skeleton and then exporting it in RDF format - GitHub - stkenny/grefine-rdf-extension: An extension to...
This lab workbook contains hands-on material supplementing the OpenRefine workshops
Don't waste the whole day cleaning up messy data from in your spreadsheets. Here's how to use the free OpenRefine tool to organize and clean up spreadsheet data in minutes.
By Luling Huang I’ve been using OpenRefine (OR; OpenRefine Development Team, 2013) for data cleaning for a while. The experience has been great. OR’s own General Refine Expression Language (GREL) is simple...
Contribute to miriamposner/get-started-with-openrefine development by creating an account on GitHub.