Data Cleaning

Id must be [Integer]

Title must be [String]

Location must be [String]

Company must be [String]

If there is no company information, the value should be 'non-specified'.

ContractType must be [String]

It could be 'full_time', 'part_time' or 'non-specified'.

ContractTime must be [String]

It could be 'permanent', 'contract' or 'non-specified'.

Category must be [String]

There are 8 possible categories: '

IT Jobs','Healthcare & Nursing Jobs','Engineering Jobs', 'Accounting & Finance Jobs', 'SalesJobs', 'Hospitality & CateringJobs', 'Teaching Jobs', 'PR, Advertising & MarketingJobs'.

Salary must be [Float]

All the values need to be expressed to two decimal places, e.g., 80000.25.

Also, all salary values must be valid float numbers and not null.

OpenDate - [Datetime]

All the values need to be in the datetime format, e.g.,2013-03-12 15:00:00

CloseDate - [Datetime]

All the values need to be in the datetime format, e.g., 2013-03-12 15:00:00

SourceName - [String]

all set to non -specified