Getting back into the swing of things
Details
We're back in action and ready to code. Join us for another Journocoders evening. We're going to kick off about 7pm.
Data journalism is all about the cleaning of messy data, this month we're going to learn how to use OpenRefine to clean and standardise datasets.
Please bring laptops and if possible have Openrefine installed. You can download it here http://openrefine.org/download.html
If you're not able to install the software, no worries we'll help you!
We're going to be working through the School of Data Tutorial on Open Refine https://schoolofdata.org/handbook/recipes/cleaning-data-with-refine/
When cleaning data you need to look out for
- Dates
- Company names
- Addresses
- Times
- Currencies
You can use their sample data or here are a few suggestions:
- 2017 EU tender contract award notices https://data.europa.eu/euodp/data/dataset/ted-csv/resource/51bbe90e-b1d2-4f5a-8b77-0724e955118c
- Residential Property price register https://www.propertypriceregister.ie/website/npsra/pprweb.nsf/PPRDownloads?OpenForm