[Tutor] Using if statement with csv file
dw
bw_dw at fastmail.fm
Tue Jan 27 23:40:50 CET 2015
Hi Tammy,
I wonder how big your csv file is?
I have ever read a small csv file into one variable.
Even a csv file with 100 rows.
And then split it into identified fields from there.
I look at the csv file with Notepad++ to see if the data rows end with a
\r or a \n.
I then split that into a list and each row is an element in the list.
I can then split each row by the comma delimiter, to resolve down to
each field.
Just an idea.
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.Thank you, Tammy
--
Bw_dw at fastmail.net
More information about the Tutor
mailing list