I have to read code from a .csv file and put specific columns of data into separate lists. However when I get to column 21 and 22 it says there is not a number there when there is when looking at the spreadsheet. Not sure what my error is since columns 0-4 work fine. The pink x and y list work fine but the yellow ones are what Im having trouble with.
pink_x = []
pink_y = []
yellow_x = []
yellow_y = []
#Calibrating Camera
file = open("meter_sticks.csv", 'r')
firstline = True
secondline = True
thirdline = True
fourthline = True
fifthline = True
line = file.readline()
i = 0
while line != '' and i <=1229:
if firstline:
firstline = False
line = file.readline()
continue
if secondline:
secondline = False
line = file.readline()
continue
if thirdline:
thirdline = False
line = file.readline()
continue
if fourthline:
fourthline = False
line = file.readline()
continue
if fifthline:
fifthline = False
line = file.readline()
continue
if line[2] == '':
line = file.readline()
continue
i+=1
line = line.split(',')
pink_x.append(int(line[3]))
pink_y.append(int(line[4]))
yellow_x.append(int(line[21]))
yellow_y.append(int(line[22]))
line = file.readline()
file.close()
print(pink_x)
print(yellow_y)Here is a portion of the .csv file i'm working with. Output:frame_no,timestamp,size_px-hotpink,position_px_x-hotpink,position_px_y-hotpink,rx-hotpink,ry-hotpink,vx-hotpink,vy-hotpink,ax-hotpink,ay-hotpink,size_px-lightorange,position_px_x-lightorange,position_px_y-lightorange,rx-lightorange,ry-lightorange,vx-lightorange,vy-lightorange,ax-lightorange,ay-lightorange,size_px-yellowneon,position_px_x-yellowneon,position_px_y-yellowneon,rx-yellowneon,ry-yellowneon,vx-yellowneon,vy-yellowneon,ax-yellowneon,ay-yellowneon
0,128.6,,,,,,,,,,30,34,133,,,,,,,,,,,,,,,
1,128.6,,,,,,,,,,32,34,135,,,,,,,,,,,,,,,
2,236.1,,,,,,,,,,30,34,134,,,,,,,,,,,,,,,
3,260.1,,,,,,,,,,30,34,133,,,,,,,,,,,,,,,
4,277.0,6,655,627,,,,,,,,,,,,,,,,7,426,431,,,,,,
5,285.7,6,655,627,,,,,,,,,,,,,,,,8,426,431,,,,,,
6,304.6,6,655,627,,,,,,,,,,,,,,,,8,426,431,,,,,,
7,304.6,6,655,627,,,,,,,,,,,,,,,,8,426,431,,,,,,
8,324.9,6,655,627,,,,,,,,,,,,,,,,8,427,431,,,,,,
9,324.9,6,655,627,,,,,,,,,,,,,,,,8,426,431,,,,,,
