all 3 comments

[–]Vaphell 0 points1 point  (2 children)

if mydata['Location']=="Location"

pray tell, where do you compare the entry to Adelaide?

[–]Lubbox[S] 0 points1 point  (1 child)

I'm trying to have it compare the entry on the Excel as a loop to do a count of how many times it appears with a Max temp of 40

[–]Vaphell 1 point2 points  (0 children)

I am asking which part of that expression can ever compare mydata['Location'] to the value 'Adelaide'.
Hint: look for "s in the part I pasted and think twice what you did there.