Skill 1.2: Clean, transform, and load the data Unless you are connecting to a dataset…