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

  • 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 ...
  • Fetch City and Province / State based on the postal code
    In the US, Canada and UK postal code are pretty good code to retrieve information on a location. In this tutorial we will use the yahoo p...
  • 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...
  • Fill down the right and secure way
    The fill down function consists of taking the content of cells and copying down following blank cells. This is done based on the rows num...
  • How to call Content Grabber API
    Content Grabber is a very powerful and easy to use software developed by Sequentum for web scraping. Its point and click interface allo...
  • 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...
  • 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...
  • Selecting a string within a cell using smartSplit
    The function smartSplit is a variation on split function that allow you to split the cell content based on any string of character and then...
  • 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...
  • 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...

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