O'Reilly logo

Using OpenRefine by Max De Wilde, Ruben Verborgh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

In this chapter, we have seen how your dataset can be transformed from an isolated island into a connected collection of data. On one hand, you can perform reconciliation on columns that contain simple field values. Therefore, the text in the cells is given meaning by adding a URL to it which can be looked up online. You can either use the built-in Freebase reconciliation or install the RDF extension which allows reconciliation against Linked Data sources. On the other hand, you can perform named-entity recognition on cells that contain flowing text, again with an extension. This lets OpenRefine search for concepts inside the cell values, and it will try to find a URL for each of them. In the end, your dataset becomes enriched with links ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required