Suljettu

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

UI: CLI

Max Budget: Rs 1000

Taidot: Python

Näytä lisää: 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

Tietoa työnantajasta:
( 7 arvostelua ) Hyderabad, India

Projektin tunnus: #17764400

14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

anupkelkar02

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 Lisää

₹3333 INR 3 päivässä
(42 arvostelua)
6.0
origami07

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. Lisää

₹3055 INR 3 päivässä
(8 arvostelua)
3.3
₹1750 INR 7 päivässä
(1 arvostelu)
1.0
Aidinteimouri

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

₹1300 INR 1 päivässä
(0 arvostelua)
0.0
muthuvelpandian

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 Lisää

₹900 INR 1 päivässä
(0 arvostelua)
0.0
₹1550 INR 3 päivässä
(0 arvostelua)
0.0
₹1250 INR 3 päivässä
(0 arvostelua)
0.0
ashishsingh183

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 1 päivässä
(0 arvostelua)
0.0
supersuntech

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. Lisää

₹1750 INR 1 päivässä
(0 arvostelua)
0.0
mrangel

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 2 päivässä
(0 arvostelua)
0.0
sowrisurya

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 1 päivässä
(0 arvostelua)
0.0
virtual3code

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 Lisää

₹1250 INR 1 päivässä
(0 arvostelua)
0.0
noranasr96nn

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 3 päivässä
(0 arvostelua)
0.0
Agarwal76

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 3 päivässä
(1 arvostelu)
0.0