Convert large xlsx file to csv and clean data

In Progress Posted Mar 5, 2016 Paid on delivery
In Progress Paid on delivery

I need this file converting from xlsx to csv (comma separated value):

[url removed, login to view]

In addition, I need a copy of the csv with the following processing:

1. Delete all rows where "PW_UNIT_OF_PAY" is not equal to "Yearly (YR)"

2. Delete all rows where "WAGE_UNIT_OF_PAY" is not equal to "Year".

3. Delete all columns apart from EMPLOYER_NAME, JOB_TITLE, and WAGE_RATE_OF_PAY_FROM

Deliverables (2 files):

1. Direct conversion of xlsx to csv file

2. Cleaned up version of csv according to above instructions.

Data Entry Excel

Project ID: #9856200

About the project

1 proposal Remote project Active Mar 6, 2016

Awarded to:

$30 USD in 1 day
(1 Review)
0.0