176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Excel: Convert Time Series in Tables to Unique Files with Header Info
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Feb 17, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Sat, Feb 16, 2013
  • 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 either a macro or a python program to perform the following task. The program should be easily re-used by myself going forward.

First, please take a look at the zipped csv file for "All Sections" here:

  [obscured]  //national/nipaweb/DownSS2.asp

You will have to pull from both "All sections" files, 1969-Present and Data through 1969, the heading information is the same, we will need combine data through 1969 with data from 1969-Present.

For every series with an ID in column C, we will need to take the time series listed to the right of the series ID (combining data from the files "through 1969" and "1969-Present"), and put it in stand alone .txt file like the attached example. So, there should be one file per series. Please note how the Table ID, Frequency, Units etc change for the tables.


Please take a look at the example now if you have not. The headings will contain 10 details, most of which are consistent throughout:

1) ...

Sign in or Register to see more

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

 Jamaica  |  
The creation of solutions is the reason that I exist. You are guaranteed quality with a reasonable price. Backing up those statements are my twenty...
6
  |  
 5.0   |  Private   |  13 Jobs   |  1 verified credential(s)
Bid ID: 38220388  |  Submitted: Feb 23, 2013 04:55 ET 
Proposal SEALED

 Philippines  |  
We are a new data entry and processing startup company. We turn your data into information that suits your needs.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38092642  |  Submitted: Feb 20, 2013 04:31 ET 
Proposal SEALED

 United States  |  
If you are looking for well engineered solutions to your software problems, contact me. I have years of experience in writing tools for data...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38015713  |  Submitted: Feb 18, 2013 11:45 ET 
Proposal SEALED

 Russia  |  
professional programmer
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38008763  |  Submitted: Feb 18, 2013 08:35 ET 
Proposal SEALED

 United Kingdom  |  
We are a new business but we have years of experience behind us. For over 10 years I have created numerous programs at work and home. These range...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38000863  |  Submitted: Feb 18, 2013 04:53 ET 
Proposal SEALED

 Australia  |  
AREAS OF SPECIALIZATION: Macros/VBA (MS Excel, Word, Outlook), Google Docs scripting, Microsoft Visual Studio Tools for Office (VSTO), MS Access,...
6
  |  
 4.7   |  Private   |  9 Jobs
Bid ID: 37989108  |  Submitted: Feb 17, 2013 21:44 ET 
Proposal SEALED

Denis Mezenok      
Denis Mezenok's identity has been verified.  Learn More
 Ukraine  |  
INVITED
Hi! I am instresting in this project and I want to work with you. I have a lot of expirience, more than 4 years, in programming using PHP, JS,...
9
  |  
 5.0   |  Private   |  15 Jobs
Bid ID: 37984230  |  Submitted: Feb 17, 2013 16:27 ET 
Proposal SEALED

 Romania  |  
INVITED
AIDevel is a privately-held Romania based company committed to offer high quality work in several areas, like Natural Language Processing, Machine...
3
  |  
 0.0   |  Private   |  3 Jobs
Bid ID: 37977179  |  Submitted: Feb 17, 2013 10:56 ET 
Proposal SEALED

Mark T.      
Mark T.'s identity has been verified.  Learn More
 Thailand  |  
19 years experience in Relational Database Design (IBM DB2, MySQL, postgreSQL, MS SQLServer, MS Access and many more ....). using PHP5, Java, J2EE,...
7
  |  
 5.0   |  Private   |  7 Jobs
Bid ID: 37976974  |  Submitted: Feb 17, 2013 10:48 ET 
Proposal SEALED

 United States  |  
INVITED
Techtropolis brings imagination to life! We provide creative, scientific, and engineering support to bring entrepreneur's dreams to reality.
4
  |  
 5.0   |  $1,238 Earnings   |  2 Jobs
Bid ID: 37976135  |  Submitted: Feb 17, 2013 10:10 ET 
Proposal SEALED

 Canada  |  
Your data is the vital core of your business. Understanding it, managing its flow, and extracting value from it is key to your success. I...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37975863  |  Submitted: Feb 17, 2013 09:56 ET 
Proposal SEALED

 China  |  
Winner
We are major in Data scraping , see our website www.topscraper.com I have worked as programmer for 7 years . Major skill in Amazon Ec2 ,Perl and...
6
  |  
 4.9   |  Private   |  6 Jobs
Bid ID: 37974748  |  Submitted: Feb 17, 2013 09:07 ET 
Delivery
Within 1 week
$219.18

 Portugal  |  
More than 15 years of programming experience. 7 years working with Visual Basic languange. 5 years working with Visual Basic for applications...
6
  |  
 4.7   |  $2,119 Earnings   |  16 Jobs
Bid ID: 37973691  |  Submitted: Feb 17, 2013 08:14 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 »