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

  • 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...
  • 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...
  • 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.
  • 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 ...
  • 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...
  • Split cell content into multiple column, non fixed field length
    I recently get a file to work on generated by crystal report and I had to deal with this format as no other were available. In my case, da...
  • Error: smartSplit error: Un-terminated quoted field at end of CSV line
    I am a big fan of the smartSplit function . It is really easy to understand and help to extract quickly part of a string based on any chara...
  • Count how often a character occurs in a cell
    Did you know that Refine can count how often an string or character appears in a cell? To achieve this, I first recommend that you store ...
  • 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...
  • Limitation when splitting and joining multi-valued cells
    Split multi-valued cells function helps to transpose data stored in one cells into multiple rows, while keeping the relationship with...

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