Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Can you help me change this in c++ update your payroll program to use a C++ class. Each employee class object should hold the master file information for one employee. You can assume that the company...

*** in java *** PinballMachineTarget.txt play.txt just looking for a good idea of how to do this code as i am stuck on it Assignment Description This assignment provides more practice creating and...

Its about malloc function and I need your help desperately..:( I know there are a lot to do.. I am working on my own but not sure I can finish them. Please help me.. Input files: 1001 1591.63 M 1011...

Directions: ( CODE IN C ONLY!!!) Complete the following homework assignment using the description given in each section. Do not email code to TAs for help. They cannot help fix compile errors via...

Purpose: Use command line arguments for input Use malloc() and free()function. Collect input from a text file. Write output to a text file. Creating integer, double and character arrays. To create...

In c++ GIVEN CODE: Location.h #ifndef _LOCATION_H_ #define _LOCATION_H_ #include using namespace std; class Location { public : // Default constructor Location(); // Default constructor Location( int...

Introduction In todays lab, we will read in a file using C++ I/O Manipulators and functions, including an introduction to the std::string object. Lab Objectives C++ File I/O + Manipulators Reading a...

a) Find the volume of BaCl 2 . 600mL of 3.00% (w/v) aqueous BaCl2 from a 0.400 M BaCl2 solution. b) Find the volume of HCl. 1.00 L of 0.285 N HCl starting with a 6.00 solution of the reagent.

At December 31, balances in Manufacturing Overhead are: Shimeca Companydebit $1,200, Garcia Companycredit $900. Prepare the adjusting entry for each company at December 31, assuming the adjustment is...

Heenam and PerImutter ( 1 9 7 9 ) classified top management's attitudes and values into three orientations. List the three.

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.