Open Data Labs - Web Foundation

  • Labs
  • Blog
  • Projects
  • Resources
  • Contact Us
  • English
    • Indonesia

Open Data Day Jakarta: A crash course in data wrangling

February 25, 2015 by Open Data Labs Leave a Comment

odd1

Last Saturday, 21 February, Open Data Day was celebrated globally. Definitely not about to miss out on this occasion, the Open Data Lab Jakarta and OpenStreetMap Indonesia came together to bring about “Open Data for Nonprofits”, an open data training dedicated to data extraction and cleaning. The event attracted a total of 14 data enthusiasts and tech experts ready to hone their (new) data processing skills through the two training sessions given.

Opening the workshop, the first session was run by the OpenStreetMap team on different tools for working with spatial data. They delved into the data extraction tool Overpass-Turbo, which allows users to extract map features and export them directly into text data. The second session was by the Open Data Lab Jakarta, wherein we demonstrated how to transform cluttered digital data into a format more apt for easy machine reading and processing. This process is often referred to as data wrangling.

Data wrangling is often done with the help of semi-automated tools, such as the most popular one, OpenRefine. This software claims – and works from our experience! – to be able to sort any messy data with less manual effort. Our Lab team gave a hands-on training demonstrating the program, and successfully awed the participants with how the tool easily detected and cleared data inconsistencies. Other features such as filtering data, identifying duplicates, splitting data, transforming data and transposing column cells to rows, were also tackled in the workshop.

odd2

The event lasted over four hours, with plenty of live showcases from the organisers, alongside a steady stream of scrumptious snacks and drinks. Moreover, given the diversity of attendees, the meet-up also served as a networking ground for different organisations to share experiences and discuss potential collaborations. There were representatives from private companies, CSOs and universities such as Google Indonesia, Satuvisi Inovasi, Transparency International Indonesia, Perludem, and Surya University. At the end of the training, everyone present left with full bellies, gained acquaintances, and most importantly, equipped with new data-handling skills.

odd3

The complete materials from the OpenRefine training session can be found in the Open Data Labs Training page.

Filed Under: Workshops and Trainings Tagged With: #OpenDataDay, jakarta, open data, training

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Archives

  • November 2020
  • October 2020
  • March 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • June 2019
  • May 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • December 2015
  • November 2015
  • October 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • October 2014

Jln. Kudus No. 3, Menteng, Jakarta 10310           @ODLabJkt           Open Data Lab Jakarta           Open Data Lab Jakarta          Privacy Policy


© 2008–2023 World Wide Web Foundation. This work is licensed under a Creative Commons Attribution 4.0 International License.