- Using OpenRefine
- Ruben Verborgh Max De Wilde
- 405字
- 2021-08-06 16:57:13
Recipe 4 – manipulating columns
In this recipe, you will learn how the columns in OpenRefine can be collapsed and expanded again, moved around in any direction, or renamed and removed at leisure.
Columns are an essential part of OpenRefine: they contain thousands of values of the same nature and can be manipulated in a number of ways.
Collapsing and expanding columns
By default, all columns are expanded in OpenRefine, which can be cumbersome if there are many in the project. If you want to temporarily hide one or more columns to facilitate the work on the others, click on the dropdown in any column to show the menu and select View. Four options are available to you:
- Collapse this column
- Collapse all other columns
- Collapse columns to left
- Collapse columns to right
Here is a screenshot of the Powerhouse dataset after navigating to View | Collapse all other columns on the column Categories. To expand a column again, just click on it. To expand all of them and go back to the initial view, see the Moving columns around section in this recipe.

Moving columns around
In some cases, it might be useful to change the order of the columns from the original file, for instance, to bring together columns that need to be compared. To achieve this, enter the menu of the chosen column and click on Edit column. Again, four options are available at the bottom of the submenu:
- Move column to beginning
- Move column to end
- Move column to left
- Move column to right
If you want to reorder the columns completely, use the first column called All. This column allows you to perform operations on several columns at the same time. The View option offers a quick way to collapse or expand all columns, while Edit columns | Re-order / remove columns... is an efficient way to rearrange columns by dragging them around or suppressing them by dropping them on the right, as shown in the following screenshot:

Renaming and removing columns
Under the same Edit column menu item, you also have the possibility to:
- Rename this column
- Remove this column
You could use renaming to suppress the unnecessary dot at the end of the Description column header, for instance. Removing a column is clearly more radical than simply collapsing it, but this can nevertheless be reversed, as you will learn by reading Recipe 5 – using the project history.
- Excel 2007函數(shù)與公式自學寶典
- AWS:Security Best Practices on AWS
- 商戰(zhàn)數(shù)據(jù)挖掘:你需要了解的數(shù)據(jù)科學與分析思維
- 21天學通C++
- 空間站多臂機器人運動控制研究
- 貫通Java Web開發(fā)三劍客
- 中國戰(zhàn)略性新興產(chǎn)業(yè)研究與發(fā)展·智能制造裝備
- 單片機技術項目化原理與實訓
- Web璀璨:Silverlight應用技術完全指南
- Hadoop Beginner's Guide
- Apache Spark Quick Start Guide
- 大型機系統(tǒng)應用基礎
- Java Deep Learning Projects
- 深度學習500問:AI工程師面試寶典
- 計算機仿真技術