Ditutup

Convert large xlsx file to csv and clean data

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

[login to view URL]

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.

Kemahiran: Pemprosesan Data, Excel

Lihat lagi: convert onix xml data csv file, compare csv file large, export table data csv file php, page data csv file html, submit form data csv file, send form data csv file asp, retrieve data csv file, import data csv file sql 2005, source code export sql data csv file vb6, upload data csv file mysql

Tentang Majikan:
( 0 ulasan ) Spain

ID Projek: #9842403

59 pekerja bebas membida secara purata $32/jam untuk pekerjaan ini

$26 USD / jam
(330 Ulasan)
7.6
prameswara

Hello Sir I can do it Sir please give me a chance for doing your job Thank You Sincerely Prameswara

$25 USD / jam
(364 Ulasan)
7.2
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

$26 USD / jam
(263 Ulasan)
7.1
deepabittu

Hello Sir, I have 5+ member team sir my team have good experience of data entry [login to view URL] my team ready now for this [login to view URL] my team give you good [login to view URL] Regards Deepabittu

$27 USD / jam
(243 Ulasan)
6.6
raghav1101

Hi, I would love to work on this project. I am a qualified chartered accountant (CPA equivalent). I have 8 years of professional experience in Microsoft Excel including working with financial modeling, macros and da Lagi

$26 USD / jam
(97 Ulasan)
6.6
mehedi276

Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can se Lagi

$38 USD / jam
(134 Ulasan)
6.2
$41 USD / jam
(94 Ulasan)
6.0
gokulanand

Hello I can get you this task completed using Excel VBA in the next 3 to 4 hours. Do let me know if you are interested. Thanks

$25 USD / jam
(100 Ulasan)
6.1
vlayausa

Hello, I have a lot of experience with Excel and VBA. I could make a macro which will do all cleaning of data and save the file as .csv. Please contact me for more information. P.S. I noticed you have 618 t Lagi

$35 USD / jam
(131 Ulasan)
5.8
romanyfahmy0

Hello dear sir/madam greetings! we can do that for you in just one day. I'm very interested in your project and ready to start immediately once you accept my bid, I'm a full time worker having all skills needed to c Lagi

$25 USD / jam
(32 Ulasan)
5.6
prabakarm23

I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I Lagi

$55 USD / jam
(50 Ulasan)
4.6
wissamSabry

I am an advanced user with over 10 years of MS Excel experience. As A Microsoft Certified System Administrator I am Excellent in word editing, processing , spread sheets I can very quickly help you with any Microsoft E Lagi

$25 USD / jam
(15 Ulasan)
4.3
mwarrenschultz

Hello! I am a professional programmer with over 7 years of data mining experience using Python. I have read your project description, and I can create the Excel (.xlxs) to CSV program you require. To do so, I will use Lagi

$41 USD / jam
(8 Ulasan)
4.4
filipal

I have several successfully completed projects but I still do not have a rating. I have long time experience with Microsoft Office ( Word, Excel), creating and editing PDF files and I make brochures. In Data Entry, Dat Lagi

$25 USD / jam
(24 Ulasan)
4.5
saadrashad

i have experience of excel(know complex formulas also) i can do that job. can u please tell me how big is the file? how many rows are there? how many columns? i have experience and can do the job easily. Lagi

$25 USD / jam
(12 Ulasan)
3.8
cheungkc

Hi The original file is 147 MB The converted csv file is 230 MB Please note "PW_UNIT_OF_PAY" only has entry of "year" and does not have "Yearly (YR)" There is no column labeled as "WAGE_RATE_OF_PAY_FROM" Plea Lagi

$27 USD / jam
(6 Ulasan)
3.1
Abikris

Hi Unfortunately, I couldn't download the file. But the after reading the description it seems an easy task for me. Award me the project along with the files and you'll get the solution within 2 days. Thanks for Lagi

$27 USD / jam
(5 Ulasan)
2.5
cracken

Hi, I, based on my 5 years of experience as a software engineer knowledgeable with tools automation, can handle this task pretty well. Let me know the best of your time so we can discuss further based on your requirem Lagi

$39 USD / jam
(6 Ulasan)
2.3
cpeznola

I have over 20 years of excel experience and I am very familiar with conversion to comma delimited. I most recently completed a 6 month project for Thomson Reuters, which was a "big data" project requiring conversion Lagi

$27 USD / jam
(1 Ulasan)
2.0
bashir786wmc

You pay me after checking the work. Hi I have read out all the details given in your project and I am fully capable to deliver you this project with 100% accuracy. I have completed many projects related to this in t Lagi

$33 USD / jam
(4 Ulasan)
2.2