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

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

主站蜘蛛池模板: 溧阳市| 兴海县| 丰顺县| 郁南县| 冀州市| 陆良县| 葫芦岛市| 平昌县| 翼城县| 金乡县| 库尔勒市| 荆门市| 西昌市| 青冈县| 德安县| 息烽县| 新密市| 万源市| 白水县| 城步| 北票市| 南丹县| 盐山县| 天镇县| 泗洪县| 海宁市| 上高县| 蒙阴县| 平度市| 望奎县| 山东省| 博乐市| 和硕县| 金川县| 濮阳市| 文水县| 康保县| 祥云县| 新化县| 郧西县| 金湖县|