Stack Overflow
Stack Overflow

Questions tagged [openrefine]

OpenRefine is the new name for the data cleaning tool which used to be called Google Refine (and was born as Freebase Gridworks)

Resources

400 questions
2
votes
1 answer

OpenRefine: How to create a unique row for each input in a column ( dilneated by comma)

I have a bunch of product data to clean prior to entry into a database that looks like this: COL A COL B COL C... "N" Option 1 A, B, C, D Option 1 attribute Option 2 C, D, F Option 2 attribute Option 3 D, J, Z Option 3 attribute And…
codeaboard
  • 63
  • 7
2
votes
0 answers

New OpenRefine install produces almost blank landing page (no menus)

OS: Windows 10 Pro 64 bit 19042.985 JDK: OpenJDK 16.0.1+9-24 OpenRefine: openrefine-3.4.1 Browser: Firefox 88.0.1 Just installed OpenRefine for the first time, on top of a fresh install of OpenJDK 16 The server runs and opens the URL…
Incans
  • 182
  • 9
2
votes
2 answers

How to construct SPARQL query for a list of Wikidata items

First off, I'm not a developer, and I'm new to writing SPARQL queries. Mostly I've been looking up existing queries and trying to tweak them to get what I need. The issue is that most documentation on query construction have to do with getting new…
Stephanie Sapienza
  • 21
  • 2
2
votes
1 answer

Regex to delete all caps letters and following comma

I have a csv of names like so Smith, SMITH, John, JOHN and I'm trying to use regex in OpenRefine to remove the names in all caps. replace(value, /^[A-Z]$/, '') does nothing and replace(value, /[A-Z]/, '') gets rid of all names with any capital…
Wiseface
  • 183
  • 2
  • 11
2
votes
1 answer

Inserting Regular Expressions into OpenRefine facets

Working in OpenRefine I want to find word pairs where the second word is 'Street'. I have a python regular expression which works for this but I can't get it to work in OpenRefine. https://regex101.com/r/igjCuo/94 show the regex working…
Jack
  • 2,245
  • 2
  • 14
  • 18
2
votes
1 answer

How to add a column that substract the difference between two existing columns ? GREL in OpenRefine

So I'm trying to find a simple way to create a new column that displays the difference between two existing columns (each with numbers)... I can't seem to find the proper GREL expression.... So I'm trying to find the amount of items sold with a…
user11713467
  • 21
  • 2
2
votes
3 answers

How can I add a string character based on a position in OpenRefine?

I have a column in Openrefine, which I would like to add a character string in each of its rows, based on the position in the string. For example: I have an 8th character number string: 85285296 and would like to add "-" at the fourth place:…
tzipy
  • 147
  • 7
2
votes
2 answers

Using OpenRefine to create a mapping table from two other tables

I have the following use case that OpenRefine seems to be a good candidate to solve. I have an existing, "dirty" product table in my database that looks like this: id name 51 Product A 52 product-a 53 product B 54 productb 55 produtc 56 …
blindsnowmobile
  • 3,868
  • 6
  • 32
  • 47
2
votes
1 answer

fetching wikidata labels in other languages from reconciled column

I want to use wikidata reconciliation to translate a column of terms into various languages by fetching the labels in those languages. Using SPARQL, I'd filter a query for label by language (this is the approach suggested in various similar cases).…
Will Hanley
  • 457
  • 3
  • 16
2
votes
1 answer

Openrefine and wikidata: how to get values (not reconciliation)

I was wondering if there's a way to take some values from wikidata through openrefine. For instance: I've got the wikidata ID of a painting. Inside Openrefine it is possible to create a new column with the wikidata author ID? Thanks
Lara M.
  • 855
  • 2
  • 10
  • 23
2
votes
1 answer

special characters in replace function

GREL replace function expects 3 strings, or a string, a regex and a string. In the 3rd string used for replacement, some characters have a special behavior : \, \, \t, \n, \', \" and maybe some other combinations. \ does nothing, or an error \ is…
Mathieu Saby
  • 125
  • 5
2
votes
1 answer

OpenRefine: 'Fill Up' replacing values along one column

I have following table ╔════════╦════════╦════════╦════════╗ ║ record ║ Brand ║ Model ║ Spec ║ ╠════════╬════════╬════════╬════════╣ ║ 1 ║ X ║ null ║ 1 ║ ║ ║ X ║ DF ║ 3 ║ ║ ║ X ║ null ║ 5 …
til
  • 832
  • 11
  • 27
2
votes
2 answers

Extracting email addresses from messy text in OpenRefine

I am trying to extract just the emails from text column in openrefine. some cells have just the email, but others have the name and email in john doe format. I have been using the following GREL/regex but it does not return the entire…
Abi Hassen
  • 23
  • 2
2
votes
1 answer

How to I install OpenRefine extensions in OntoRefine

Is it possible to use OpenRefine extensions in OntoRefine (part of GraphDB 8.3)? And if yes, how? What version of OpenRefine is OntoRefine based on?
Peter
  • 870
  • 6
  • 20
2
votes
1 answer

Open Refine--create new column by looking up values from a pair of columns

I have a table in OpenRefine with columns A, B, and C like this: A | B | C | D ---|---|---|--- a | 1 | b | 2 b | 2 | | c | 3 | a | 1 d | 4 | c | 3 I want to create a column D by fetching the values from B corresponding to those in C, using…
Will Hanley
  • 457
  • 3
  • 16
1 2 3
…
26 27