Cleaning Messy Data

Every spreadsheet you inherit is a small archaeological site. Names are spelt three ways. Dates are half text, half numbers. Phone numbers have plus signs, brackets, dashes, or nothing at all. One column secretly contains three things.

This lesson is about getting that file into a shape you can actually use, with AI as the assistant who does the boring part.