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¶meter2='
for i = 1 to 30
MyNewUrl = MyUrl & 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
Platform: Amazon AWS EC2
Ubuntu 16.04.4 LTS
Max Budget: Rs 1000
14 freelancers are bidding on average ₹1780 for this job
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.