import csv
import os, sys

ifile  = open('test.csv', "rb")
reader = csv.reader(ifile)
row=3
tn=[]
tncol=-1
sp=[]
spcol=-1
ra=[]
racol=-1
dec=[]
deccol=-1
rownum = 0
#for line in reader and rownum < row+1:
while row !=0 and rownum < row+1: 
    line=reader.next()
    # Save header row.
    if rownum == 0:
        print "XXX"
        header = line
	colnum = 0
        for col in line:
        	if (header[colnum].lower()=="showclass"):
			tncol=colnum
        	if (header[colnum].lower()=="targetnam"):
			tncol=colnum
        	if (header[colnum].lower()=="specid"):
			spcol=colnum
        	if (header[colnum].lower()=="ra" or header[colnum].lower()=="obsra"):
			racol=colnum
        	if (header[colnum].lower()=="dec" or header[colnum].lower()=="obsdec" ):
			deccol=colnum
		colnum += 1

    else:
         print "YYY"
	 print rownum
#        colnum = 0
#        for col in line:
#            print '%-8s: %s' % (header[colnum], col.strip())
#            colnum += 1
	 if abs(rownum-row) <= 1:
	        tn.append(line[tncol].strip())    
    rownum += 1

print "here"
print tncol,spcol
print tn
print len(tn)
print tn.index("g2356212-293125")	
ifile.close()