HW help for a noob

[jdb]

Rather confused with what I'm doing wrong. First CS course and I'm stuck on this part. I need to import the CSV file from excel named "data.csv", but I have zero clue as to why this code is wrong. Thanks for your help. Below is the code.



import csv
path = data.csv
def mean(ch):
A = list()
file = open(path, newline="")
reader1 = csv.reader(file)
next(reader1)
for row in reader1:

A.append(int(row[ch-1]))
return(sum(A)/len(A))

The error is "Unidentified name 'data'"

[Larz60+]

please read BBCODE
and post code between code tags, use shift-ctrl-v to preserve indentation.

see: https://docs.python.org/3/library/csv.html for info on reading/ writing csv files

[sparkz_alot]

Also post the error code in it's entirety between the error tags.

[gruntfutuk]

You need to put the name of the file in quotes.

You need to call the function you defined.

I assume the ch argument is meant to indicate which column (field) of data you want to get the mean of, counting from 1 (hence the ch-1 referencing as Python counts from 0).

import csv
path = 'data.csv'
def mean(ch):
    A = list()
    file = open(path, newline="")
    reader1 = csv.reader(file)
    next(reader1)
    for row in reader1:
        A.append(int(row[ch-1]))
    return(sum(A)/len(A))
    
print(mean(1))