RefinePro Knowledge Base for OpenRefine

Build over time, the RefinePro knowledge base list tutorials, how to and tips for OpenRefine (formerly Google Refine)

6.6.23

OpenRefine May 2023 Review

9:06 PM  

We wish you a very happy June! This month, we decided to share the most relevant and helpful OpenRefine May 2023 community announcement, videos, and academic publications with you. Read on to discover them.


English Videos:

  • Segmenting categorical cell by OpenRefine
  • Querying Art History Data on the Web (5/7): Modelling Data with OpenRefine
  • R : Best way to parse a big and intricated Json file with OpenRefine (or R)
  • Segmenting categorical cell by OpenRefine
  • Converting JSON to Excel in OpenRefine
Spanish Video:
  • ¿Cómo subir imágenes con OpenRefine?

Academic Publications:

  • Use of OpenRefine in "Data Wrangling from Socio-Academic Web-Space: Designing a Meta Model"
  • Use of OpenRefine in "Automatic Indexing for Agriculture: Designing a Framework by Deploying Agrovoc, Agris and Annif"
  • Use of OpenRefine in "Digital handlungsfähige Erinnerungskultur - Neue Ansätze für forschendes Lernen vor Ort"
  • Use of OpenRefine in "SkoHub - Das Potential kontrollierter Vokabulare nutzen"
  • Use of OpenRefine in "The application of Linked Open Data to the creation of book numbers"

Email ThisBlogThis!Share to XShare to Facebook
Older Post Home

RefinePro Social Media

  • Popular
  • Tags
  • Archive

Popular

  • Google refine ; JSON and my notepad or how to write script in google refine
    One of the nice thing about google refine is that every action you do generate a JSON code. If we want to do a comparison with Excel, the ...
  • Google Refine Usage Survey Results
    Following the survey on Google Refine usage we distribute last week I would like first thanks the 99 persons who participated. Thanks to yo...
  • From Freebase Gridworks to Google Refine and now OpenRefine
    Yesterday David Huynh announced that Google will soon stop its active support of Google Refine and count of community to get more involve...
  • Prepare SQL SELECT, INSERT INTO, DELETE query using OpenRefine
    I know that a lot of us export data from MySQL / SQL databases to clean them in OpenRefine before loading them back in their original datab...
  • OpenRefine: Create an empty column
     Sometimes you just need to add a new empty column to your OpenRefine project. The process is straight forward as we show in this video tuto...
  • Compare values from two columns
    To compare strings from 2 differents column and present the results in a third one, use the following expression:
  • Remove duplicate rows
    This is a quick tutorial to re move duplicate rows or records based on on e field. This turial is adapated (add screenshot) from David ...
  • Difference between a record and a row
    Google refine make a clear distinction between a row and a record. We will see what's the difference between the two and advantages to ...
  • Parse mark up language (JSON, html, xml ...)
    In this tutorial we will see how to parse mark up language like JSON, html or xml. Those language are great to parse because there is oft...
  • vlookup in google refine
    vlookup is a very useful formula in Excel and it has is equivalent in google refine under the name cell.cross. Using this expression you...

Labels

  • 311
  • apache
  • API
  • around the web
  • captcha
  • cluster
  • compare
  • concatenate
  • Content Grabber
  • copy
  • CouchDB
  • countif
  • course
  • cross
  • cURL
  • custom export
  • data exploration
  • docker
  • duplicate
  • editing
  • exercise
  • export
  • extension
  • extract
  • facet
  • facetCount
  • fetch url
  • fill down
  • fingerprint
  • flag
  • forEach()
  • fusion table
  • geocoding
  • gephi
  • good practices
  • grel
  • gridworks
  • history
  • hosting
  • html
  • if
  • index
  • introduction
  • join
  • JSON
  • map
  • merge
  • merge dataset
  • move
  • multi-valued cells
  • NationBuilder
  • ngram
  • open corporate
  • OpenRefine
  • OpenRefine 3.3
  • padding
  • parse
  • parsehub
  • Perl
  • postal code
  • postman
  • project creation
  • publish
  • RDF extension
  • recipe
  • reconciliation
  • record
  • refine 2.1
  • refine 2.5
  • RefinePro
  • regex
  • remove
  • replace
  • research paper
  • smartSplit
  • sort
  • split
  • sql
  • survey
  • template
  • timeline
  • toDate
  • toNumber
  • toTitlecase
  • transpose
  • tutorial
  • twitter
  • upload
  • video
  • vlookup
  • web scraping
  • xml

Blog Archive

  • ▼  2023 (6)
    • ▼  June (1)
      • OpenRefine May 2023 Review
    • ►  April (1)
    • ►  March (2)
    • ►  January (2)
  • ►  2022 (16)
    • ►  December (1)
    • ►  November (1)
    • ►  September (1)
    • ►  August (1)
    • ►  July (2)
    • ►  May (3)
    • ►  April (2)
    • ►  March (2)
    • ►  February (1)
    • ►  January (2)
  • ►  2021 (14)
    • ►  December (1)
    • ►  October (1)
    • ►  September (1)
    • ►  August (2)
    • ►  June (1)
    • ►  May (2)
    • ►  April (2)
    • ►  March (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2020 (17)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (2)
    • ►  August (1)
    • ►  July (1)
    • ►  June (2)
    • ►  May (1)
    • ►  March (3)
    • ►  February (2)
    • ►  January (1)
  • ►  2018 (3)
    • ►  September (2)
    • ►  June (1)
  • ►  2015 (7)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2014 (7)
    • ►  December (1)
    • ►  October (1)
    • ►  September (1)
    • ►  July (1)
    • ►  April (3)
  • ►  2012 (39)
    • ►  December (1)
    • ►  November (4)
    • ►  October (10)
    • ►  September (4)
    • ►  August (2)
    • ►  June (7)
    • ►  April (3)
    • ►  March (2)
    • ►  February (3)
    • ►  January (3)
  • ►  2011 (33)
    • ►  December (1)
    • ►  November (4)
    • ►  October (8)
    • ►  September (6)
    • ►  August (2)
    • ►  July (8)
    • ►  June (4)
Your subscription could not be saved. Please try again.
Your subscription has been successful.

Subscribe to receive our monthly OpenRefine roundups with new tutorials, release updates and community announcements.

 
Copyright © 2011 RefinePro Knowledge Base for OpenRefine | Powered by Blogger
Design by NewWpThemes | Blogger Theme by Lasantha