Changing cases

Text data can be particularly tricky to clean and prepare. This is partly due to a higher frequency of errors made during data collection, such as typos and inaccuracies in survey responses, and also due to the complexity of analyzing written language.

Following an unfortunate IT error, the original spreadsheet containing the highest grossing films became slightly corrupted, which altered the case and spacing of entries in the Director column. Your job is to apply your new text cleaning skills to recreate the original column!