Clusterování Textu - Blog

OpenRefine.json

[
  {
    "op": "core/column-rename",
    "description": "Rename column Column 1 to Originální produkty",
    "oldColumnName": "Column 1",
    "newColumnName": "Originální produkty"
  },
  {
    "op": "core/column-addition",
    "description": "Create column Clusterované produkty at index 1 based on column Originální produkty using expression grel:value",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "newColumnName": "Clusterované produkty",
    "columnInsertIndex": 1,
    "baseColumnName": "Originální produkty",
    "expression": "grel:value",
    "onError": "keep-original"
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Clusterované produkty",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "Clusterované produkty",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "LEGO-Friends 3061: City Park Cafe - AKCE",
          "LEGO-Friends 3061: City Park Cafe - Akce",
          "LEGO-Friends 3061: City Park Kafe - Akce",
          "LEGO-Friends 3061: City Park Cafe - akce"
        ],
        "to": "LEGO Friends 3061: City Park Cafe"
      },
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "LEGO-Friends 3061: City Park Cafe",
          "Lego Friends 3061: City Park Cafe",
          "LEGO Friends 3061: City Park Cafe",
          "Lego-Friends 3061: City Park Cafe"
        ],
        "to": "LEGO Friends 3061: City Park Cafe"
      }
    ]
  },
  {
    "op": "core/mass-edit",
    "description": "Mass edit cells in column Clusterované produkty",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "Clusterované produkty",
    "expression": "value",
    "edits": [
      {
        "fromBlank": false,
        "fromError": false,
        "from": [
          "LEGO Friends 3061: City Park Cafe",
          "LEGO Friends (3061) City Park Cafe",
          "LEGO Friends 3061: City Park Cafe - Dráčik",
          "LEGO Friends 3061: City Park Cafe - GLOBUS",
          "LEGO Friends 3061: City Park Cafe - Globus",
          "LEGO Friends 3061: City Park Cafe - Tesco Zličín",
          "LEGO Friends 3061: City Park Cafe 3 x paleta (SK)",
          "LEGO Friends 3061: City Park Cafe 3 x paleta (SK) - DHL",
          "LEGO Friends 3061: City Park Cafe 3 x paleta (SK) - PPL",
          "LEGO Friends 3061: City Park Cafe 3*paleta",
          "LEGO Friends 3061: City Park Cafe 3xpaleta",
          "lego friends /3061/ City-Park Cafe"
        ],
        "to": "LEGO Friends 3061: City Park Cafe"
      }
    ]
  }
]