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 dataset, which can be downloaded from the Packt website. Following any of these recipes will turn you into an advanced OpenRefine user. Caution: some hardcore data operations ahead.