Reading in data from text files

In Progress

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.

Skills: C Programming, C++ Programming, Perl

See more: stack programming, programming with data, programming in perl, data programming, care source, stretch, letter G, identifying, clean files, files missing, hours dates, missing columns data, text row, vertical columns, column text, hour programming, reading header file, year date column, missing data file, clean text, programming report, date week year, date week number, covers programming, clean text file

Project ID: #818743

Awarded to:

gedgey

Please see PM

$50 USD in 1 day
(4 Reviews)
2.7

39 freelancers are bidding on average $95 for this job

$150 USD in 0 days
(28 Reviews)
6.3
ineedWorkJob

sir plz check pm !

$80 USD in 0 days
(95 Reviews)
6.3
Mindon

check the PM please

$120 USD in 3 days
(52 Reviews)
6.0
poetatom

Hello, I can do this using c/c++ with Visual Studio. Please let me help you. Poetatom

$100 USD in 2 days
(6 Reviews)
5.9
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$250 USD in 7 days
(24 Reviews)
5.8
deadhunt

I have large expirience in C/C++ programming, check PMB.

$50 USD in 1 day
(55 Reviews)
5.6
HussienSharaf

HI, I m expert in processing huge data. Hussien Sharaf

$180 USD in 3 days
(13 Reviews)
5.2
zeke

Dear Customer! I have a lot of experience writing data parsing scripts. Ready to start immediately and finish as soon as possible. My bid is for fast professional service exciting my customers. Please contact in PMB More

$100 USD in 1 day
(25 Reviews)
4.9
Wonderer

Need more info (sample data file) Thanks Al

$125 USD in 2 days
(12 Reviews)
4.8
CatBasil

I can do this

$100 USD in 3 days
(1 Review)
4.2
rakib062

hi, expert c/c++ programmer here. plz send me a sample file. this is a very easy task and can be completed in a short time. thanks

$50 USD in 1 day
(15 Reviews)
4.3
muthusuba

Initial Bid. Please check PMB. Thank you!

$150 USD in 3 days
(3 Reviews)
3.8
TheArseneLupin

Ho, I can do using a combination of shell script + c program (or only a C program if you use linux). I usually do a similar task to parse drivers(I work in STMicroelectronics STAPI team) test reports and produce an SD More

$70 USD in 1 day
(16 Reviews)
3.4
ZeusMan

Looking forward to working with you...

$30 USD in 0 days
(3 Reviews)
2.8
sublimecode

Please see your inbox. Thank you for your consideration.

$100 USD in 2 days
(5 Reviews)
2.5
freelancerbuzzo

Ready to start right now.

$100 USD in 5 days
(5 Reviews)
2.4
sigutis

I can do this

$100 USD in 3 days
(7 Reviews)
2.4
Mxdmg

Hi, I am C# developer and I can deliver a program which will fit your demands.

$40 USD in 3 days
(1 Review)
2.1
SmartGuru

Hello, I will be glad to deliver you a solution for providing a clean text file with data. Please check PMB for further details. Kind regards.

$50 USD in 1 day
(1 Review)
2.0
rhrh

I can do this with PERL

$200 USD in 3 days
(1 Review)
1.0