[portland] List Index Out Of Range

[Rich Shepard]

   I have an exception thrown for an index error that I do not see. Running
the script through winpdb gives me no more insight into why the error is
there (on line 27).

Traceback (most recent call last):
   File "./wide-to-long.py", line 27, in <module>
     output.write(str(chems[h]))
IndexError: list index out of range

Here's the script:

#!/usr/bin/env python

import sys

"""
First row of input file is list of chemical constituents. Following rows have
site ID, sample date, and a quantity for each constituent.
"""
filename = sys.argv[1]

infile = open(filename, 'r')
output = open("out.txt","w")

# read column headers into a list
chems = infile.readline().split(',')
h = 0 # header list index

# read each data line
d = 2 # data list index

for line in infile.read().split('\n'):
   data = line.split(',')
   output.write(str(data[0]))
   output.write(',')
   output.write(str(data[1]))
   output.write(',')
   output.write(str(chems[h])) # site of index error.
   output.write(',')
   output.write(str(data[d]))
   output.write('\n')
   if h <= len(chems):
     h += 1
   if d <= len(chems):
     d += 1

infile.close()
output.close()

------------------------------

   Sample data:

Ag,Al,CO3,HCO3,AlkTot,As,Ba,Be,Bi,Ca,Cd,Cl,Co,Cr,Cu,DO,Fe,Hg,K,Mg,Mn,Mo,Na,NH4,NO3NO2,oil_grease,Pb,pH,Sb,SC,Se,SO4,Sr,TDS,Tl,V,Zn
D-1,2007-12-12,-0.005,0.106,-1.000,231.000,231.000,0.011,0.000,-0.002,0.000,100.000,0.000,1.430,0.000,-0.006,0.024,4.960,4.110,,0.000,9.560,0.035,0.000,0.970,-0.010,0.293,,0.025,7.800,-0.001,630.000,0.001,65.800,0.000,320.000,-0.001,0.000,11.400
D-1,2008-03-15,-0.005,-0.080,-1.000,228.000,228.000,0.001,0.000,-0.002,0.000,88.400,0.000,1.340,0.000,-0.006,0.014,9.910,0.309,0.000,0.000,9.150,0.047,0.000,0.820,0.224,-0.020,,0.025,7.940,-0.001,633.000,0.001,75.400,0.000,300.000,-0.001,0.000,12.400
D-1,2008-06-26,-0.005,0.116,6.700,118.000,124.000,0.010,0.000,-0.002,0.000,63.400,0.000,1.750,0.000,-0.006,0.020,4.320,2.830,0.000,0.000,9.550,0.020,0.000,0.653,-0.010,-0.050,,0.025,8.650,0.001,386.000,-0.001,68.500,0.000,480.000,-0.001,0.000,5.500

   A clue stick appropriately applied will be very helpful.

TIA,

Rich