Advanced OpenRefine: Intro to GREL

  • Event: 2019 CAR Conference
  • Speaker: Martin Magdinier of OpenRefine
  • Date/Time: Friday, Mar. 8 at 11:30am
  • Location: Diamond Cove - conference level
  • Audio file: No audio file available.

There is so much more to OpenRefine than the clustering and faceting feature. This session is a deep dive to GREL, OpenRefine expression language (the equivalent of Excel formulas). After a thorough introduction to GREL syntax, we will review the most common functions to explore and clean up your dataset. 

Functions covered in this session include replace, split, concatenate, string comparison, if, cell.cross (to join multiple projects together), and forEach. 

This session is good for: People who are familiar with OpenRefine or with at least some Excel experience. For an introduction to OpenRefine, check out the scheduled demo session.

Speaker Bios

  • Coming from a business background, Martin’s focus is on data management and transformation tools that empower the end user who can place data in context. In 2011 Martin started to blog tips and tutorials about OpenRefine in order to help other users get the most out of this open source tool. In 2012, when Google released the software to the community, Martin helped to structure the new organization. @magdmartin

Related Tipsheets

No tipsheets have yet been uploaded for this event.