[Tutor] Using if statement with csv file

Mark Lawrence breamoreboy at yahoo.co.uk
Tue Jan 27 19:59:37 CET 2015


On 27/01/2015 18:20, Danny Yoo wrote:
> On Tue, Jan 27, 2015 at 5:04 AM, Tammy Miller <tgmiller5 at hotmail.com> wrote:
>> I have a csv file. I would like to create a filter or if statement on a column but it is not producing the right results. It displays everythingHere is the example:import csvwith open('test.csv') as csvfile:    reader = csv.DictReader(csvfile)for row in reader:    if row['Absent'] > 10      print rowI just want the column Absent to show me all of the numbers that are greater than 10.  It gives me all the results.  I am not sure what to do.
>
> Hi Tammy,
>
> Ah.  Take a look at the following:
>
> ########################
>>>> 'foo' > 10
> True
> ########################
>

Meanwhile in the non-Luddite world of Python 3.

 >>> 10 > '10'
Traceback (most recent call last):
   File "<stdin>", line 1, in <module>
TypeError: unorderable types: int() > str()
 >>> '10' > 10
Traceback (most recent call last):
   File "<stdin>", line 1, in <module>
TypeError: unorderable types: str() > int()

-- 
My fellow Pythonistas, ask not what our language can do for you, ask
what you can do for our language.

Mark Lawrence



More information about the Tutor mailing list