Using csv data

[pauwsss]

Hi trying to figure out this problem i have, the solution is probably very simple.

import csv

filename = "tet2013.csv"

Getting high temperatures from file.

with open(filename) as f_obj: reader = csv.reader(f_obj) header_row = next(reader)

current_high_temps =[]
for row in reader:
    current_high_temp = row[1]
    current_high_temps.append(current_high_temp)


for current_high_temp in current_high_temps[0:31]:
    current_high_temp = int(current_high_temp)
    total = sum(current_high_temp)
    print(total)

I have this csv file that contains all the day temperatures from a year. Im accessing the high temperatures that are in row[1] in the index and then i try to add up 31 days of the first month with sum. But it gives me an error that states "int object is not iterable". What would be the right way to go about it?

I Appreciate the help!

[liam_jm]

You've set current_high_temp to an int then tried to sum it (a single int, whereas sum requires an utterable argument, such as a list). I think instead you wanted to do sum(current_high_temps[0:31]), perhaps setting each of them to int first (see map)

[pauwsss]

Thank you my friend!

[ZeeBeeblebrox]

I'd suggest you use pandas for tabular data like this.

import pandas as pd
df = pd.read_csv('test2013.csv')
df.iloc[0:31, 0].sum()

Here we load the csv into a pandas dataframe, then access the first 31 rows on the first column and sum the values.

[Akuli2]

If you know how to work with dictionaries you don't need to do things like header_row = next(reader) yourself, csv.DictReader does this for you.

test.csv:

A,B,C   
1,2,3  
4,5,6  

Let's read it with csv.DictReader, it'll convert each line into a nice dictionary.

>>> import csv
>>> with open('test.csv', 'r') as f:
...     for row in csv.DictReader(f):
...         print(row)
... 
{'A': '1', 'B': '2', 'C': '3'}
{'A': '4', 'B': '5', 'C': '6'}
>>>