Problem with If statement and dataframe

Problem with If statement and dataframe - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Problem with If statement and dataframe (/thread-29685.html)

Problem with If statement and dataframe - Milfredo - Sep-16-2020

I am trying to use an If statement with a Dataframe. Without the If statement the Dataframe prints out beautifully, But it prints out all 63 rows. I am trying to check if field in Dataframe matched user input. Can someone tell me what I am doing wrong?

def load_track_to_Handi():
	my_tracklabel= Label(root, text ="                                                                               ", fg= "#F50808", font = ("sans_serif" , 16)).place(x=380, y=430)
	read_csvfile_into_array()
	
		
	global track_abrev
	global race_number
	global xx
	
	#if fileFound ==True:

		
		 
	
	
	hcount = 0
	
	with open( 'C://guis/f_racefiles/'+ track_abrev + '.csv' , 'r') as race_file:

		
		df = pd.read_csv(race_file, header =None)
		
		xx = df.iloc[ :,0:19 ].values
		
		

		for i in range(0,len(xx)):
			if (xx[hcount][1] == race_number):
				print(xx)[hcount][18])					
				hcount+=1

I remove if statement and prints out with no problem. Race number is an integer and I believe the field in the dataframe is an interger also, as it is a race number.

RE: Problem with If statement and dataframe - Milfredo - Sep-16-2020

This is the printout I get when I remove the if statement. I am trying to match user input (racenumber0 with the 2nd column in the dataframe, with the code in above post.

[['AP ' 1 'D' ... 42 3.0 'EYE ON THE FINISH']
['AP ' 1 'D' ... 46 10.0 'GODSGIFT']
['AP ' 1 'D' ... 82 8.0 'LILLET']
...
['AP ' 8 'D' ... 35 6.0 'WILDCAT LITE']
['AP ' 8 'D' ... 46 15.0 'GREELEYS ICE']
['AP ' 8 'D' ... 29 12.0 'JIVE DADDY']]

This was the code I changed and it worked. I am amazed...LOl.

for i in range(0,len(xx)):
			if int(xx[hcount][1])== int(race_number):
			 
				print(xx[hcount][18])					
				hcount+=1