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...
  • 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...
  • 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...
  • 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 ...
  • 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.
  • 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...
  • 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...
  • Announcing RefinePro
    Less than two weeks ago we announced the start up of RefinePro as a new participant of the OpenRefine ecosystem. This post provides backgr...
  • Google Refine Reconciliation Service support for Apache Standbol (from around the web)
    Add support for the Reconciliation Service API to the Apache Stanbol Entityhub RESTful API ( see documentation ). The Google Refine Recon...
  • How to: convert easting/northing into lat/long for an interactive map
    How to: convert easting/northing into lat/long for an interactive map  Google Fusion Tables is great for creating interactive maps from a...

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