Script to Organize Data

IN PROGRESS
Bids
11
Avg Bid (USD)
N/A
Project Budget (USD)
$50 - $100

Project Description:
I need a script (in any language) to organize data from different files into one giant file. I have tables in xls and pdf files. I am not sure about the feasibility of extracting data from pdfs using a script. If this cannot be automated, then I will pay for the manual input by the provider. The detailed instructions and the data set are listed below as attachments. Please check them before bidding.

Additional Project Description:
12/11/2012 at 4:29 SAST
I am attaching a sample of the output file. I realized that quarter is not needed. Ignore the quarter field in the above docx.

12/12/2012 at 23:57 SAST
I realize a small difference in how things are coded for the 1999-2002 pdfs, instead of Metropolitan County and Non-metropolitan County, it has Suburban Counties and Rural Counties. Let have two other fields called isSuburbanCounty and isRuralCounty to account for these years. Also, you can put missing values for pdfs from 1996 to 1998 for all the "isXXXX" fields, because they are not there.

Skills required:
C Programming, Data Processing, Excel, PDF, Python
Additional Files: Script+to+Organize+Data.docx Data.zip Example.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.