Emplifi Interview Question

How would you clean up this csv data using python