Small Project: Python script to download file, merge, do vlookup from master csv, filter to match criteria and output result in csv

I need your help to write a simple script to perform below actions.

1. download csv files in loop. I have 1 url which will have one variable parameter which is an incremental number to be looped

for reference: this is what I have written in VB

MyUrl = 'https://somewebsite.com/parameter1=something&parameter2='

for i = 1 to 30

MyNewUrl = MyUrl & i

Call DownloadCsvFunction(MyNewUrl)

next i

2. all the downloaded csv files needs to be merged to 1 csv file

3. perform vlookup kind of function to assign values

3.a. I have a master file (csv) which contains full name, code1, code 2 and code 3

3.b. in consolidated file 1 column will have full name, do a vlookup and get corresponding code1, code2, code3 from master csv file

3.c. append the vlookup results on each row end

4. filter the consolidated csv file column1="X" column2="Y" column3="Z" column4="A" column5="B"

5. filtered rows should be then output as [login to view URL] file

System Environment:

Platform: Amazon AWS EC2

Ubuntu 16.04.4 LTS

Python 2.7.12


Max Budget: Rs 1000

Kemahiran: Python

Lihat lagi: script download file, python script modify file content, python script automatic file transfer ftp, python script download vimeo, batch script download file hours, python script modify file data, python script download historical data yahoo, python script download email attachments, python script read file, script download file csv, perl script download file, python script download website pdf, php script download file server, script download file browser, small project jsp mysql download upload file, script download file client side

Tentang Majikan:
( 7 ulasan ) Hyderabad, India

ID Projek: #17764400

14 pekerja bebas membida secara purata ₹1780 untuk pekerjaan ini


I am a Python data science expert with experience in Classification and partitioning,Nureal Networks, Association rules. Also I am a Oracle Certified professional (OCP) with experience in Oracle,MySQL, SQL Server Lagi

₹3333 INR dalam 3 hari
(42 Ulasan)

Salutations, I have been developing scripts in the python environment for many years. I can complete your project. I must have a milestone created and complete specifications sent before i can do anything at all. Lagi

₹3055 INR dalam 3 hari
(8 Ulasan)
₹1750 INR dalam 7 hari
(1 Ulasan)

I am professional python programmer and I think I can help you on your problem. Let me know if you are interested.

₹1300 INR dalam sehari
(0 Ulasan)

Hi, Happy to help you on the solution for your problem statement. I have gone through your requirement and I am sure I will be able to deliver successfully. I have quite good experience in Python and there exist Lagi

₹900 INR dalam sehari
(0 Ulasan)
₹1550 INR dalam 3 hari
(0 Ulasan)
₹1250 INR dalam 3 hari
(0 Ulasan)

Hi , I am experienced python developer however I do not have Ubuntu is it OK for you if I give you windows script and you change it back for Ubuntu .

₹1450 INR dalam sehari
(0 Ulasan)

I am a hard worker with fast learning capability. A results-driven, customer-focused, diligent and analytical Software Engineer who strive for self-development. Strong in design and integration problem solving skills. Lagi

₹1750 INR dalam sehari
(0 Ulasan)

Stand out from the rest of the freelancers, by being pinned to the top of the employer's bid list. There is only one sponsored bid per project.

₹3888 INR dalam 2 hari
(0 Ulasan)

I am a student in IIIT. I want to know if i can help you based on my knowledge. I wish I get this project and start earning. This would be my first income.

₹1450 INR dalam sehari
(0 Ulasan)

Hello there, Greetings from Jaydeep. I have go through with your requirements. I have 1 year hands on experience in Python. and I have more than 3 years of experience in Programming. I will use pandas library for re Lagi

₹1250 INR dalam sehari
(0 Ulasan)

i study computer engineering, i knew python since 3 years, i worked by python many projects in the college and many jobs, i passionate in my work

₹1000 INR dalam 3 hari
(0 Ulasan)

I have been working on python since 3 years. My major work is related to data extraction and manipulation. Would love to take this up

₹1000 INR dalam 3 hari
(1 Ulasan)