Working with messy data sets is a common challenge.

What are your favorite tools or techniques for cleaning and transforming data to make it analysis-ready?