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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.