Emplifi interview question

How would you clean up this csv data using python