OpenRefine/Training
.svg){kind=link}
OpenRefine is a free data wrangling tool that can be used to process, manipulate and clean tabular (spreadsheet) data and connect it with knowledge bases ("spreadsheets on steroids" / "a swiss army knife for data"). It is widely used by librarians, in the cultural sector, by journalists and scientists, and is taught in many curricula and workshops around the world.
Self-paced online training
[edit ]The following online training programs are available entirely for free and can be followed at your own pace.
- The online Library Carpentry course for OpenRefine is a standard, and is highly recommended. While it is written for librarians and information workers, it is very relevant for all OpenRefine users, including Wikimedians.
- Language: English.
- Entirely free and self-paced.
- Approximate time to do course: 2 hours.
- Can be done by anyone with a Wikimedia account. Click here to start the course.
- Language: English
- Entirely free and self-paced
- Approximate time to do course:
- Can be done by anyone with a Wikimedia account.
- Languages:
- English - start course: OpenRefine for Wikimedia Commons: the basics
- Spanish / Español - start course: OpenRefine para Wikimedia Commons: conceptos básicos
- French / Français - start course: OpenRefine pour Wikimedia Commons : les bases
- Italian / Italiano - start course: Introduzione all'uso di OpenRefine per Wikimedia Commons
- Portuguese (coming soon).
- Entirely free and self-paced, with computer-graded tests and exercises.
- Approximate time to do course: 6 to 8 hours.
In-person training
[edit ]Do you want to receive individual or group training and advice around OpenRefine? You can contact the following people and organization(s).
Individuals
[edit ]Certified trainers
[edit ]The following trainers have successfully completed the 6-month OpenRefine-Wikimedia Train-the-trainer program (2023-24):
- Ada Jakubowska (Wikimedia Poland)
- Bart Magnus (meemoo, Belgium)
- Carla Toro Fernández (Wikimedia Chile)
- Tamsin Braisher (Wikimedia Aotearoa New Zealand)
- Giovanna Fontenelle (Culture & Heritage team, Wikimedia Foundation)
- Jinoy Tom Jacob (Wikimedians of Kerala User Group)
- Max Kristen (Kristbaum, Germany)
- Lucas Nascimento Belo (Wiki Movimento Brasil)
- Rute Correia (Wikimedia Portugal)
- Sara Thomas (Wikimedia UK)
- Will Kent (Wiki Education Foundation)
Other OpenRefine-Wikimedia trainers
[edit ]The following people also offer OpenRefine training related to Wikimedia:
- Pierre-Yves Beaudouin (Wikimedian in residence, Université Côte d'Azur)
- (your (user)name here)
You can also find trainers in the category OpenRefine trainers here on meta.wikimedia.org.
Organizations
[edit ]
The Wiki Education Foundation
[edit ]- Paid courses; both standardized and customized to your needs
- For individuals and organizations, also cultural institutions
- Offers training in English
- Web: https://wikiedu.org/
- Contact: Will Kent will@wikiedu.org