Thank you kindly in advance for help on this topic:
I am almost finished with writing a program that averages 10-minute column data and outputs the 10-minute data into hourly averages in a separate txt file - the program executes and outputs to the output file perfectly for use by another program. A sample of the input file is attached below. The 0 column is the date in yymmdd, the 1st column is the time in hhmm form and the other columns are wind data. This last step of my program requires me to fill in missing hours with a value such as -9999 for the hour in which all of the data is missing for that hour as shown below. In the sample below there is no data for hours 1000, 1100, 1200 and 1300. For these missing data rows I need to insert the correct date, time and -9999 for the other missing data columns (columns 2-6). 080618 0950 5.10 7.40 224.0 -3.54 -3.67 080618 1000 4.62 7.00 227.0 -3.38 -3.15 080618 1410 5.19 7.30 232.0 -4.09 -3.20 In my program I am reading all the data from the input txt file in a large "for loop" shown below - whereby fileObj is my open statement to the txt data input file: for line in fileObj: lineList = line.strip().split() Thank you, Randall P. Benson Please be advised that email addresses for Iberdrola Renewables personnel have changed to first.l...@iberdrolaren.com effective Aug. 16, 2010. Please make a note. Thank you. This message is intended for the exclusive attention of the recipient(s) indicated. Any information contained herein is strictly confidential and privileged. If you are not the intended recipient, please notify us by return e-mail and delete this message from your computer system. Any unauthorized use, reproduction, alteration, filing or sending of this message and/or any attached files may lead to legal action being taken against the party(ies) responsible for said unauthorized use. Any opinion expressed herein is solely that of the author(s) and does not necessarily represent the opinion of the Company. The sender does not guarantee the integrity, speed or safety of this message, and does not accept responsibility for any possible damage arising from the interception, incorporation of viruses, or any other damage as a result of manipulation.
_______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor