官术网_书友最值得收藏!

  • 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.

主站蜘蛛池模板: 克拉玛依市| 房山区| 佛坪县| 内丘县| 巴林右旗| 浦东新区| 信阳市| 阿拉善盟| 青铜峡市| 阆中市| 进贤县| 河东区| 镇雄县| 伊川县| 历史| 鲁甸县| 乐陵市| 丹江口市| 黎城县| 施甸县| 鄂托克前旗| 曲靖市| 光泽县| 龙陵县| 黔东| 广宁县| 长春市| 天峨县| 容城县| 崇明县| 惠东县| 宁乡县| 竹溪县| 威远县| 新平| 邢台县| 嫩江县| 望城县| 安宁市| 九龙坡区| 台州市|