Now we have obtained our dataset from the Edinburgh Open Data store, we need to tidy it up and see if we need to transform…