OpenRefine script for cleaning IW transparency CSV data http://www.iwight.com/Council/transparency/Our-Finances/Transparency-Our-Finances/Spending-and-Finance2

openrefine_iwtransparency.json

[
  {
    "op": "core/column-rename",
    "description": "Rename column Capital or Revenue to CapitalOrRevenue",
    "oldColumnName": "Capital or Revenue",
    "newColumnName": "CapitalOrRevenue"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column Transaction Number to TransactionNumber",
    "oldColumnName": "Transaction Number",
    "newColumnName": "TransactionNumber"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column Service Area to ServiceArea",
    "oldColumnName": "Service Area",
    "newColumnName": "ServiceArea"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column Expenses Type to ExpensesType",
    "oldColumnName": "Expenses Type",
    "newColumnName": "ExpensesType"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column Supplier Name to SupplierName",
    "oldColumnName": "Supplier Name",
    "newColumnName": "SupplierName"
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Amount using expression grel:value.replace(',','')",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Amount",
    "expression": "grel:value.replace(',','')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Amount using expression value.toNumber()",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Amount",
    "expression": "value.toNumber()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Date using expression grel:value.toDate('dd.mm.yy').toString('yyyy-mm-dd')",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Date",
    "expression": "grel:value.toDate('dd.mm.yy').toString('yyyy-mm-dd')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  }
]