Question

Note: This is the only question for this star and only the age range will change. Save and test your code in repl.it so you can paste it for credit in case you don't get it right on the first try. You are analyzing the results of a survey about the Internet and you want to know how often a specific age range of people use the Internet. You will be given a file containing a subset of the source data in the format "eminuse,intmob,intfreq,age" where all values are well-formed integers. This header will be the first line of the file and the column values are: eminuse Do you use the Internet? 1: yes 2: no intmob Do you use the Internet on mobile?

1: yes 2: no intfreq How often do you use the Internet? 1: Almost constantly 2: Several times a day 3: Once a day 4: Several times a week 5: Once a week or less Empty String: Responder answered 2 to eminuse and intmob age Responders age in years Note: The file has been filtered. If you download the original file you will have to add additional logic to handle responses of 8: Don't know, 9: Refused to answer, etc.

###The question is here in python. I can't seem to solve it

Write a function named "internet_histogram" that takes no parameters and does not return a value. There will be a file named "survey.csv" in the testing environment containing survey results as described above (the file has a header line which much be addressed by your code). Write a new file named "histogram.csv" containing 2 columns representing "internet_use,frequency" and no header line that will contain a histogram of the results of responders ages 34 to 53 including the endpoint ages. Your file will have exactly 6 lines with internet_use values of 1-5 corresponding to the intfreq results and 6 for responders who answered 2 to eminuse. Read the survey results file and track how many responders in this age range answered with each of these 6 options and write these counts to your "histogram.csv" file in order of internet_use starting with 1. Example histogram.csv: 1,5 2,7 3,0 4,1 5,2 6,4

Answer 1

def internet_histogram():
count_6 = 0
count_5 = 0
count_4 = 0
count_3 = 0
count_2 = 0
count_1 = 0
with open("survey.csv",'r') as f:
    reader = csv.reader(f)
    with open("histogram.csv", 'w') as g:
        writer = csv.writer(g)
        next(reader)
        for line in reader:
            if int(line[3]) >= 31 and int(line[3]) <= 47:
                if int(line[0]) == 2:
                    count_6 +=1
                if line[2] != '':
                    if int(line[2]) == 1:
                        count_1 += 1
                    elif int(line[2]) == 2:
                        count_2 += 1
                    elif int(line[2]) == 3:
                        count_3 += 1
                    elif int(line[2]) == 4:
                        count_4 += 1
                    elif int(line[2]) == 5:
                        count_5 += 1
        arr = [[1, count_1], [2, count_2], [3, count_3], [4, count_4], [5, count_5], [6, count_6]]
        for i in arr:
            writer.writerow(i)