A great video tutorial from free your metadata which show you how to:
You can download the data set and find back all the step on their clean up tutorial page.
- Import the collection into Google Refine
- Get to know your data
- Remove blank rows
- Remove duplicate rows
- Split cells with multiple values
- Remove blank cells
- Cluster values
- Remove double category values
You can download the data set and find back all the step on their clean up tutorial page.