CSV: list index out of range error

[ApoorvaDesai]

How do I check if a certain column exists in the CSV file, from the following code I try to check if s[8] exists. It gives me an error INDEX ERROR: List index out of range. If its Null I expect it to print NO rather than give me an error

f = open('C:\\Documents and Settings\\adesai\\Desktop\\save_lines.csv','r')
 
        while f:
            line = f.readline()
            if not line:
                break
 
            s = line.split(',')
 
 
            if s[8]:
                    print "YES"
            else:
                    print "NO"        

[bvdet]

How do I check if a certain column exists in the CSV file, from the following code I try to check if s[8] exists. It gives me an error INDEX ERROR: List index out of range. If its Null I expect it to print NO rather than give me an error

f = open('C:\\Documents and Settings\\adesai\\Desktop\\save_lines.csv','r')
 
        while f:
            line = f.readline()
            if not line:
                break
 
            s = line.split(',')
 
 
            if s[8]:
                    print "YES"
            else:
                    print "NO"        

To avoid the IndexError exception, you can check for s[8] in a try/except block:

try:
    if s[8]:
        print "Yes"
except IndexError, e:
    print "No"