Before analyzing or visualizing data we've collected, it's important to clean and prepare it. Typical tasks include fixing spelling, removing duplicate rows, finding and replacing text, changing number formats and merging and splitting columns. This workshop will familiarize you with OpenRefine, a powerful data manipulation tool that cleans, reshapes and edit batches of messy and