Chapter 3. Advanced Data Operations

In the previous chapter, we introduced you to the basic data operations in the OpenRefine universe. While this provides you with the skills to analyze your data methodically and perform basic editing activities, the true power of OpenRefine only emerges when you dive into its more advanced features. This chapter will therefore shed light on the following:

  • Recipe 1 – handling multi-valued cells
  • Recipe 2 – alternating between rows and records mode
  • Recipe 3 – clustering similar cells
  • Recipe 4 – transforming cell values
  • Recipe 5 – adding derived columns
  • Recipe 6 – splitting data across columns
  • Recipe 7 – transposing rows and columns

Feel free to jump directly to the recipes you like. This chapter starts out from the cleaned ...

Get Using OpenRefine now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.