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

  • Update phone number format
    This post is a quick adaptation to phone number based on the method presented in the add a space to postal code (splitByLength and Merge fu...
  • Remove or replace a specific character in a column
    You want to remove a space or a specific character from your column like the sign # before some number.
  • 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...
  • 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...
  • remove " (quotation) mark
    Hard time removing the " (quote sign) from your expression. Instead of quoting your quote mark with double quote, do it with simple l...
  • Move data from a column to an other
    Some data are messy and column can be a mix of different type of data. For example if you work on an address database, you might have a ZI...
  • 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...
  • Add a space to postal code (splitByLength and Merge function)
    This short tips explains how to convert postal code store on 6 characters to 7 by adding a space after 3 digits. We will use splitByLength ...
  • 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...

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