176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Python script: download and process csv files
Sign in to Add to Watch List

IT & Programming > Web Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Dec 21, 2011
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, Dec 20, 2011
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I need a Python script that does the following:

- generate a list of urls from arguments passed from sys.argv
- path of text file with list of domains
- beg_date (YYYY-MM-DD)
- end_date (YYYY-MM-DD)
- list of report names eg [report1, report2, report3, ... ] (8 reports in total)
- for each url, append "&format=csv" parameter which will returns a csv file

- log into client dashboard via Python Splinter Firefox browser (I don't think mechanize will work as login has javascript I think)
- for each url:
- request url and download each csv file
- wait for file to download (large date ranges can take several minutes to process/download)
- process csv file (example attached)
- clean up data from csv file
- remove $ and commas in numbers
- quotes should be removed when inserted into db in next step
- for each report type:
- if no table for report, create table in sqlite db = dashboard.db
- insert rows of...

Sign in or Register to see more

Desired Skills
Python, SQLite Administration
Job ID: 27679743
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 France  |  
Web, software and embedded systems programmer. C, C++, Java, Matlab,Python, Perl, HTML, CSS, JS, PHP, MySQL,..
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 27692444  |  Submitted: Dec 21, 2011 05:54 ET 
Proposal SEALED

 Egypt  |  
INVITED
- Over 12 years of software development professional experience. - Excellent Python development skills. - Excellent knowledge of development under...
5
  |  
 5.0   |  Private   |  2 Jobs
Bid ID: 27682648  |  Submitted: Dec 20, 2011 14:51 ET 
Proposal SEALED

 Ukraine  |  
Winner
Seasoned sysadmin, Big Data developer/analyst.16 years of experience in IT area. Ph.D. in Applied Mathematics.
11
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 27681692  |  Submitted: Dec 20, 2011 13:45 ET 
Delivery
Within 3 days
$210.00

 India  |  
Agami technologies was incepted in late 2011 by qualified engineers who are ready to do technical and challenging work at any time. Agami Team is...
4
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 27680793  |  Submitted: Dec 20, 2011 12:24 ET 
Proposal SEALED

 Italy  |  
Always looking for new interesting opportunities over the last 13 years in software industry, I developed for various firms applications in java...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 27680643  |  Submitted: Dec 20, 2011 12:15 ET 
Proposal SEALED

 Germany
Software engineer with 5 years experience developing quality client and web applications.
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 27680502  |  Submitted: Dec 20, 2011 12:05 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »