What can you do with OpenRefine?

OpenRefine is perfect for speeding up repetitive tasks by replaying previous actions on multiple datasets. Additionally, journals, granting agencies, and other institutions are requiring documentation of the steps you took when working with your data.

Do people still use OpenRefine?

Usage frequency remains globally the same since 2012, with about a third using OpenRefine weekly, a third using it monthly, and a third using it less than once per month.

How do I start OpenRefine?

With openrefine.exe​ You can run OpenRefine by double-clicking openrefine.exe or calling it from the command line. If you want to modify the way openrefine.exe opens, you can edit the openrefine.

Who uses OpenRefine?

5 companies reportedly use OpenRefine in their tech stacks, including infoculture, APICrafter, and Sponsokit.

How do you cluster in OpenRefine?

How to Cluster

1. On the column of your choice, perform a “Text facet.” At the top of the facet window, select the “Cluster” option. OR.
2. Go to the column you would like to cluster and click the arrow button on the column header, then select the “Edit cells” option and choose “Cluster and edit.”

Who Uses OpenRefine?

5 companies reportedly use OpenRefine in their tech stacks, including infoculture, APICrafter, and Courtsdesk.

How do I remove blank cells in OpenRefine?

That can be done by the “blank down” feature. Click on the column -> Edit cells -> Blank down. To remove the duplicates entirely, select the column -> Facet -> Customized facets -> Facet by blank (null or empty string).

How do I remove blank rows in OpenRefine?

Remove blank rows To remove these rows, click the triangle in front of the first column called ‘All’, select ‘Edit rows’, and then ‘Remove all matching rows’.

How do I increase OpenRefine memory?

Using openrefine.exe The line “-Xmx1024M” defines the amount of memory available in megabytes. Change the number “1024” – for example, edit the line to “-Xmx2048M” to make 2048MB [2GB] of memory available.

Is OpenRefine secure?

Data stored by OpenRefine on your computer is not encrypted by default. You can make sure data stored by OpenRefine is encrypted by setting up full disk encryption in your operating system.

What is a facet in OpenRefine?

Facets are one of the most useful features of OpenRefine and can help in both getting an overview of the data and to improve the consistency of the data. A ‘Facet’ groups all the values that appear in a column, and then allows you to filter the data by these values and edit values across many records at the same time.

What is OpenRefine and how do I use it?

OpenRefine is a popular open-source tool for cleaning and transforming data. This tutorial will teach you how to use OpenRefine to clean metadata pulled from Socrata open government data (OGD) portals.

How do I use OpenRefine to clean my name?

Although OpenRefine can do a myriad of cleaning tasks, this tutorial will just cover the basics of cleaning through an exercise dealing with inconsistently entered names. To start using OpenRefine, go to this page to download it and follow directions to install it. Once you’ve installed it, launch OpenRefine.

How to transform data in Excel using OpenRefine?

Tutorial: OpenRefine 20 To transform data, we should choose one row and click Edit Cells and then Transform. Function 1: value + ” (string)” Function 2: value.trim().length() Tutorial: OpenRefine 21 Some Functions at a Glance

How do I create a project in OpenRefine?

In OpenRefine, navigate to the menu on the left-hand side of the browser and select the “Create Project” tab. Choose the data file we just downloaded. The next screen you’ll see is a preview screen. This shows you how OpenRefine sees and your data and allows you to change settings before you import it.