Reading in data from text files

This project was awarded to gedgey for $50 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

We have text files that contain hourly data on traffic volume on a highway. Each file covers a year's worth of data and we have 10 such files. The text file is organized as a vertical stack of weekly reports. Each report has a header identifying the week, location, data source etc and so the headers are largely repititive. Of interest are the hourly counts which are presented below the header. The columns represent individual dates and the rows represent hours (24 rows in all.) The row labels identify the hour (e.g. "1-2") and the column labels identify the date (e.g. "FEB 18"). Each report ends with a footer that has various summary statistics. Sometimes, the hourly data are missing (blank) and usually the hourly data number is followed by a letter (e.g. "A") which denotes the relevant stretch of the highway. We only care about the hourly traffic volume number for each date in the data. We would like a clean text file that has 3 columns: date (ddmmyy), hour, traffic volume.

Awarded to:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online