Question

python, please!!!

comma separated values to store the data. The hame_count.csv file has one header row, of the form: name, count Each successive row then has a name and a count for how many times that name appears in a database of names that the lab made up. For this first part of the lab, you must calculate the average name count. The steps to do so are as follows: Open the file, name_count.csv • Read all the lines from the file into a list For each line in the file... o If the row is the first row, skip it (there are multiple ways to do this). Otherwise... o Split the row to get the count (the number after the comma) o Add that count to a total_sum of all the counts • Divide the total_sum of all the counts by the number of counts and print the result This should be somewhat similar to some homework problems you have had in the past. The expected answer is 5.74:

Answer 1

f=open('name_count.csv')
data=f.readlines()
f.close()
first=True
total_sum=0
num_counts=0
for line in data:
if first:
first=False
else:
name,count=line.split(',')
total_sum+=int(count.strip())
num_counts+=1
print('Average name count:',total_sum/num_counts)
  

f=open('name_count.csv') data=f.readlines) f.close() first-True total_sum=0 num_counts=0 for line in data: if first: first=False else: name, count=line.split(',') total_sum+=int(count.strip ) num_counts+=1 print('Average name count:',total_sum/num_counts) Average name count: 38.25

jupyter name_count.csvv a few se File Edit View Language 1 name, count 2 name1,34 name2,54 name3,33 name4,32