Thad Guidry edited this page on 8 Nov · 21 revisions

Editing cells.

What is a Cell ?

Each cell in an OpenRefine project contains a value of a specific ‘type’. The types supported are:

  • String
  • Number
  • Date
  • Boolean
  • error
  • null

The first four are Data Types. The Data Type will determine what you can do with the value. For example, if you want to sum two values by adding them together, they must both be of Numbertype.

error is when the cell is storing an error generated during a transformation in OpenRefine.

null is a special value which basically means ‘this cell has no value’ (see https://techterms.com/definition/null for a slightly fuller definition).

Further details of our Data Model are in a section on this wiki page: Server-Side-Architecture#data-model

一個資料處理的好東西。

在資料分析的第一步需要做資料清理。批次整理資料，其中的好處是會幫你記錄你所有的步驟

下次再匯入資料的時候，不需要再重做一次

https://cognitiveclass.ai/courses/introduction-to-openrefine/

 

Hits: 117