import csv and then be able to add year revenue

Sun, 11 Jul 2010 22:08:08 -0700

here is my csv file
[quote]
2009|1|22|56.23
2009|4|12|86.24
2009|5|20|34.67
2009|6|22|12.67
2009|3|21|795.12
2008|7|4|753.43
2008|8|9|2345.45
2008|9|1|2357.23
2010|5|2|7552.21
2010|3|15|666
2010|4|17|2323.75
2010|5|19|2367.23
2010|6|25|6453
2010|2|6|1267.12
[/quote]

here is my code

import csv

print ("Enter the year you want to add up the total revenue.")


reader = csv.reader(open("/revenue.csv", "rb"))
for row in reader:
    print(row)

here is what i have so far...sorry i am very new to python but am really enjoying it. any help would be greatly appreciated.

thanks
keith

Re: import csv and then be able to add year revenue

Sun, 29 Aug 2010 08:34:47 -0700

You have to split the row:

values = row.split('|')

this create a tuple of the values:

('2009', '1', '22', '56.23')

You can then access the columns by
values[0] etc.
Be aware that this values are strs.
You need to convert them to float if you want to make a sum.

v = float(values[3].strip())

Here v will be 56.23
strip() removes whitespaces, just to be sure.

Hope it helps:
Imre Horvath

'import csv and then be able to add year revenue' Thread RSS Feed

import csv and then be able to add year revenue

Re: import csv and then be able to add year revenue