OpenRefine is the new name for the data cleaning tool which used to be called Google Refine (and was born as Freebase Gridworks)
Resources
Questions tagged [openrefine]
400 questions
-1
votes
2 answers
OpenRefine - remove first dot in every word
I am using OpenRefine and have values like:
33.469.444 or 3.333.444
which I want to convert to:
33469.444 or 3333.444
So I want to remove the first dot (".") in every word.
Anyone has a clue?
-1
votes
1 answer
Where does openrefine store projects?
I would like to know where does openrefine store projects' information. I've version controlled openrefine's folder but apparently none of its contents have been changed so I guess that there must be somewhere else.
ccamara
- 1,141
- 1
- 12
- 32
-1
votes
1 answer
multidimensional rdf datacube and google refine
I am trying to convert some multidimensional databases (3 columns-dimensions, 1 column value) to RDF datacube using google refine. Because I have some problems with the modeling, is there any good example (or some ready RDFs with that structure)…
-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
-2
votes
6 answers
How to delete least filled duplicate rows?
I have excel with Survey Results.
There are multiple submissions(rows) by the same email.
I want to find the most filled / most completed row and delete the rest of the duplicate rows with the same email address.
I have a table like this. Multiple…
Kombuwa
- 1,613
- 4
- 20
- 35
-2
votes
1 answer
How to create temporal/virtual files?
I need to save a list in a temporary or virtual file that after being executed in a linux terminal from a python, the temporary file must be deleted.
This is the list:
formato_db=[{'op': 'core/column-reorder', 'columnNames': ['\ufeffNúmero de…
frankh07
- 41
- 4
-2
votes
2 answers
OpenRefine text transform delete all characters from character "["
I want to delete all characters after the "[" character like the screenshot below:
Schreenshot
How do I achieve this?
rafatomillero
- 5
- 3
-2
votes
1 answer
Clean unstructured place name to a structured format
I have around 300k unstructured data as below screen.I'm trying to use Google refine or OpenRefine to make this correct. However, I'm unable to find a proper way to do this. I'm new to this tool. Anyone's help would be greatly appreciated.Also, this…
AskMe
- 2,495
- 8
- 49
- 102
-3
votes
1 answer
How to parse value out of column in OpenRefine
I have the results from Google place details. I would like to parse the phone number out of it. How could I do so? I am using OpenRefine and using fetching column on the basis of another column.
Vijay
- 15
- 5
-3
votes
1 answer
getting error while importing rdf
i was trying to import freebase rdf to google refine but getting an error....but now how to extract topic names with notable type from 18 gb rdf to csv etc....any gui tool ?
user2216267
- 491
- 3
- 8
- 21