Data Cleaning

LI: To be able to organise large data sets

In this lesson, we’re going to be cleaning! Well, cleaning data. Last week, the data you worked with was very challenging. That’s because it wasn’t formatted properly.

Task

Clean the data by doing the following:

• Remove column A
• Rename column B, 'Area’
• Change all the data to 1 decimal place
• Rename the headings from tasDecMedian to Dec Median
• Make the headers bold
• Centre all the data
• Format the column widths