22

I'm a programmer and I use OpenRefine all the time. Some of the advantages it has over breaking out Python or some other language include: results of transformation expressions are previewed interactively with live data quick, interactive, filter facets which allow for easy browsing of instances/rows which match a variety of filters exploratory analysis of ...


7

I think the best benefit from OpenRefine is its GUI. You can always do everything OpenRefine offers you with Python, Java, etc. but for non-programmers it helps them to perform basic (and sometimes not so basic) operations with data without having to learn how to code.


7

If you're comfortable with R, probably not a whole lot. OpenRefine's sweet spot is for facilitating data management for non-programmers, and packaging together a bunch of common data-munging tasks behind nice point-and-click interfaces. Sunlight (my employer) has used it a fair bit for this purpose, if researchers need to be able to clean up some data ...


4

If you're doing this interactively, most browsers will format tables as TSV when they're selected and cut. Pasting this into the clipboard dialog of Refine's project creation dialog will allow you to import the data as TSV. If you've got a bunch to do or need to do this repeatedly, I'd use Google Spreadsheet's importHtml(url,"table",N) function which will ...


3

As is often the case when handling HTML tables you will most likely need to save the table into an intermediate format that OpenRefine can accept. This is straightforward for a simple table, and is a reasonable solution for a small amount of data. As an example, consider the simple HTML table on this webpage. First, select the table and copy to the ...


2

The documentation page on OpenRefine website point out to the official wiki a list of tutorials and the discussion list for your project specific questions. Like @Joe pointed out, I am not sure what are your looking for exactly. Maybe you can explain what you are tying to learn and why the book or existing documentation doesn't address your challenge. (...


1

Have a look at these three videos if you like watching tutorials. Otherwise the list mentioned by @magdmartin is quite extensive.


Only top voted, non community-wiki answers of a minimum length are eligible