Software:OpenRefine

From HandWiki
Short description: Application for data cleanup and data transformation
OpenRefine
OpenRefine favicon (2018-present).svg
Developer(s)Freebase, then Google, now open source community
Initial releaseNovember 10, 2010; 13 years ago (2010-11-10)
Written inJava[1]
PlatformMicrosoft Windows, Linux, macOS
Available inEnglish, Italian, Chinese, Japanese, French, German
Type
LicenseBSD License

OpenRefine is an open-source desktop application for data cleanup and transformation to other formats, an activity commonly known as data wrangling.[2] It is similar to spreadsheet applications, and can handle spreadsheet file formats such as CSV, but it behaves more like a database.

It operates on rows of data which have cells under columns, similar to the manner in which relational database tables operate. OpenRefine projects consist of one table, whose rows can be filtered using facets that define criteria (for example, showing rows where a given column is not empty).

Unlike spreadsheets, most operations in OpenRefine are done on all visible rows, for example, the transformation of all cells in all rows under one column,[3] or the creation of a new column based on existing data. Actions performed on a dataset are stored the project and can be 'replayed' on other datasets. Formulas are not stored in cells, but are used to transform the data. Transformation is done only once.[4] Formula expressions can be written in General Refine Expression Language (GREL),[5] in Jython (i.e., Python), and in Clojure.[6]

The program operates as a local web app: it starts a web server and opens the default browser to 127.0.0.1:3333.

Uses

  • Cleaning messy data: for example if working with a text file with some semi-structured data, it can be edited using transformations, facets and clustering to make the data cleanly structured.[7]
  • Transformation of data: converting values to other formats, normalizing and denormalizing.
  • Parsing data from web sites: OpenRefine has a URL fetch feature and jsoup HTML parser and DOM engine.[8]
  • Adding data to dataset by fetching it from web services (i.e. returning JSON).[9] For example, can be used for geocoding addresses to geographic coordinates.[10]
  • Aligning to Wikidata (formerly Freebase[11]): this involves reconciliation — mapping string values in cells to entities in Wikidata.[12]

Supported formats

Import is supported from following formats:[13]

  • TSV, CSV
  • Text file with custom separators or columns split by fixed width
  • XML
  • RDF triples (RDF/XML and Notation3 serialization formats)
  • JSON
  • Google Spreadsheets[14]

If input data is in a non-standard text format, it can be imported as whole lines, without splitting into columns, and then columns extracted later with OpenRefine's tools. Archived and compressed files are supported (.zip, .tar.gz, .tgz, .tar.bz2, .gz, or .bz2) and Refine can download input files from a URL. To use web pages as input, it is possible to import a list of URLs and then invoke a URL fetch function.

Export is supported in following formats:[15]

  • TSV
  • CSV
  • Microsoft Excel
  • HTML table
  • Google Spreadsheets
  • Templating exporter: it is possible to define custom template for outputting data, for example as MediaWiki table.

Whole OpenRefine projects in native format can be exported as a .tar.gz archive.

Development

OpenRefine started life as Freebase Gridworks, developed by Metaweb and has been available as open source since January 2010.[16] On 16 July 2010, Google acquired Metaweb,[17] the creators of Freebase, and on 10 November 2010 renamed Freebase Gridwords Google Refine, releasing version 2.0.[18] On 2 October 2012, original author David Huynh announced that Google would soon stop its active support of Google Refine.[19][20][21] Since then, the codebase has been in transition to an open source project named OpenRefine.[22]

References

  1. ↑ "OpenRefine/OpenRefine - GitHub". https://github.com/OpenRefine/OpenRefine. 
  2. ↑ "openrefine.github.com". http://openrefine.org/. 
  3. ↑ "Editing by transforming: Cell Editing wiki page from Refine documentation". https://code.google.com/p/google-refine/wiki/CellEditing#Editing_by_Transforming. 
  4. ↑ "Comparison with spreadsheet software: Cell Editing wiki page in Refine documentation". https://code.google.com/p/google-refine/wiki/CellEditing#Comparison_with_Spreadsheets_Software. 
  5. ↑ General Refine expression language OpenRefine/OpenRefine Wiki GitHub. Github.com (2013-04-03). Retrieved on 2013-08-16.
  6. ↑ "Expressions: Refine documentation". https://code.google.com/p/google-refine/wiki/DocumentationForUsers#Expressions. 
  7. ↑ "Screencast: Google Refine 2.0 - Introduction (1 of 3) - editing government data". https://www.youtube.com/watch?v=B70J_H_zAWM. 
  8. ↑ "Stripping HTML: Refine documentation wiki page". https://code.google.com/p/google-refine/wiki/StrippingHTML. 
  9. ↑ "FetchingURLsFromWebServices wiki page: Refine documentation". https://code.google.com/p/google-refine/wiki/FetchingURLsFromWebServices. 
  10. ↑ "Screencast: Google Refine 2.0 - Data Augmentation (3 of 3) - using Openstreetmap Nominatim for geocoding and Freebase for augmentation". https://www.youtube.com/watch?v=5tsyz3ibYzk. 
  11. ↑ "Schema Alignment: Refine documentation wiki page". https://code.google.com/p/google-refine/wiki/SchemaAlignment. 
  12. ↑ "OpenRefine documentation: Reconciliation". https://github.com/OpenRefine/OpenRefine/wiki/Reconciliation. 
  13. ↑ "Importers: Refine documentation wiki page". https://code.google.com/p/google-refine/wiki/Importers. 
  14. ↑ "Changelog for 2.5". https://code.google.com/p/google-refine/wiki/ChangesFor2p5. 
  15. ↑ "Exporting: Refine documentation wiki page". https://code.google.com/p/google-refine/wiki/Exporters. 
  16. ↑ "Google Code Archive - Long-term storage for Google Code Project Hosting.". https://code.google.com/archive/p/google-refine/source. 
  17. ↑ "Google Official Blog: Deeper understanding with Metaweb". http://googleblog.blogspot.com/2010/07/deeper-understanding-with-metaweb.html. 
  18. ↑ "Google Opensource blog: Announcing Google Refine 2.0, a power tool for data wranglers". http://google-opensource.blogspot.com/2010/11/announcing-google-refine-20-power-tool.html. 
  19. ↑ "Google Groups". https://groups.google.com/forum/#!topic/openrefine/a3R6afKb4-4. 
  20. ↑ "From Freebase Gridworks to Google Refine and now OpenRefine". http://kb.refinepro.com/2012/10/from-freebase-gridworks-to-google.html. 
  21. ↑ OpenRefine . OpenRefine. Retrieved on 2013-08-16.
  22. ↑ google-refine - Google Refine, a power tool for working with messy data (formerly Freebase Gridworks) - Google Project Hosting. Code.google.com. Retrieved on 2013-08-16.

External links



Retrieved from "https://handwiki.org/wiki/index.php?title=Software:OpenRefine&oldid=3451060"