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 = ''

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

Skills: Python

See more: 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

About the Employer:
( 7 reviews ) Hyderabad, India

Project ID: #17764400

14 freelancers are bidding on average ₹1780 for this job


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 More

₹3333 INR in 3 days
(42 Reviews)

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. More

₹3055 INR in 3 days
(8 Reviews)
₹1750 INR in 7 days
(1 Review)

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

₹1300 INR in 1 day
(0 Reviews)

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 More

₹900 INR in 1 day
(0 Reviews)
₹1550 INR in 3 days
(0 Reviews)
₹1250 INR in 3 days
(0 Reviews)

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 in 1 day
(0 Reviews)

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. More

₹1750 INR in 1 day
(0 Reviews)

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 in 2 days
(0 Reviews)

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 in 1 day
(0 Reviews)

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 More

₹1250 INR in 1 day
(0 Reviews)

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 in 3 days
(0 Reviews)

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 in 3 days
(1 Review)