Interview Guides

You're working on a data pipeline and need to prepare raw data before it can be used for analysis or reporting. The focus is on how you clean messy inputs and structure them into something reliable for downstream use.
What methods do you use for data cleaning and preparation?