Python, for all its power and popularity, has long lacked a form of flow control found in other languages—a way to take a value and match it elegantly against one of a number of possible conditions.

This guide will walk you through the basics of automating data cleaning in Google Sheets using Python and Pandas.