Stack Overflow
Stack Overflow

Questions tagged [grel]

GREL is the transformation expression language for OpenRefine (formerly Google Refine), a data wrangling application. Originally, GREL stood for "Google Refine Expression Language". Now it is usually expanded as "General Refine Expression Language".

GREL is the transformation expression language for OpenRefine (formerly Google Refine), a data wrangling application. Originally, GREL stood for "Google Refine Expression Language". Now it is usually expanded as "General Refine Expression Language".

69 questions
0
votes
2 answers

Extract text after a string using GREL

I'm trying to add a column based on a column in OpenRefine using GREL. Here is an example of the original cell data: https://www.example.com/notice/search/woa/(type)/SOMEWORD I want to extract: SOMEWORD So I need to extract everything after the…
TinyTiger
  • 1,801
  • 7
  • 47
  • 92
0
votes
2 answers

Create column in OpenRefine using a logic test on an existing column?

I have an original data set with over 4,500 row entries representing land transactions. One of the existing columns is "Place," and in each cell value I've put the locality name usually as Some Neighborhood, but sometimes when there is a place I…
grad student
  • 111
  • 1
  • 4
0
votes
2 answers

Delete everything before a double quote

I'm trying to clean a CSV file which has a column with contents like this: Sometexthere1", "code"=>"47.51-2-01"}] And I would like to remove everything before the first quote (") in order to keep just this: Sometexthere1 I know that I can use $`…
abaporu
  • 320
  • 2
  • 12
0
votes
1 answer

How to generate random numbers with GoogleRefine or OpenRefine in GREL?

I'd like to generate random numbers in GREL. Is there any way to do this? I'd like to use a GREL phrase like: "http://example.org/id/" + random + ".html"
CH_
  • 685
  • 1
  • 7
  • 18
0
votes
2 answers

OpenRefine text transform unique() ignoring case

Is there a way to tell uniques() to ignore case? I have a GREL that runs like forEach(value.split(","),v,v.trim()).uniques().join(",") This takes each value in the cell seperated by commas, and then spits out the unique value/s in that cell. Works…
Paul M
  • 3,937
  • 9
  • 45
  • 53
-1
votes
1 answer

How can I filter large amount of JSON in OpenRefine?

I'm using OpenRefine to pull in information on publisher policies using the Sherpa Romeo API (Sherpa Romeo is a site that aggregates publisher policies). I've got that. Now I need to parse the returned JSON so that those with certain pieces of…
fionaglasgow
  • 1
  • 1
-1
votes
1 answer

How do i tell Openrefine to fetch some data trough the google and facebook API (Grel)

I have a list of around 500 foundations and companies and i need to fetch more data like address, description, lat long, email or phone number, from the google and FB APIs I have found something more or less like this, but it won't work in…
He11bran
  • 3
  • 3
-1
votes
3 answers

How to add numbers to a string with Python or GREL

I have >4000 numbers in a column that need to be manipulated.. They look like this: 040 413 560 89 or 0361 223240 How dow I put it into the folllowing format: +49 (040) 41356089 or +49 (0361) 223240 They all need to have the same country dialling…
Mac
  • 1
  • 2
-2
votes
1 answer

OpenRefine: How to delete content of cells if it matches specific string pattern?

So I'm doing my first project in OpenRefine and I don't fully get the GREL thing and how to transform my proeject with it yet... Problem is: I have a column in which I want to delete ONLY the contents of the cells that match a specific pattern and…
jasmin
  • 3
  • 4
1 2 3 4
5