Question

Question 2 (10 points) (quality.py): We are provided with data from a quality control process in a manufacturing firm. The data file, "data.csv", contains several measurements. Each measurement is written in a separate line and each line contains two elements, the area where the measurement is made, and the measured value. These two values are separated with a comma (.). We are tasked to process this data in the following forms. a. First, we need to read the data from the provided file. Develop a function called load data that accepts a filename parameter, which is a string value for the input filename. This function should read the content of the provided file, process them (e.g., make proper conversion for numerical values), and return two lists, one for areas where the measurement is made, and the list of measured values. b. Develop a function called print_overall stats that accepts a parameter, which is a list of measured values (output from part a.), and prints the overall statistics for the values. This function should print count, maximum, minimum, average, and standard deviation for the provided data set. Below is an example output from this function. Make sure to properly format float values to only show 2 decimal places. Overall Statistics: Count: 1000 Maximum: 1160.61 Minimum: 0.00

Answer 1

import statistics
from collections import defaultdict

def write_area_measures(area, area_list, value_list):
    file_name = area + "_data.csv"
    with open(file_name, 'w') as write_file:
        for area_val, value in zip(area_list, value_list):
            if(area_val.strip() == area.strip()):
                write_file.write(str(value)+ "\n")


def print_area_stats(area_list, value_list):
    area_dict = defaultdict(list)

    for area,value in zip(area_list,value_list):
        area_dict[area].append(value)

    for area in area_dict.keys():
        print("\nArea : ", area)
        print_overall_stats(area_dict[area])


def print_overall_stats(value_list):
    print("Overall Statistics")
    print("\t Count: ", len(value_list))
    print("\t Maximum: ", min(value_list))
    print("\t Minimum: ", max(value_list))
    print("\t Average: ", round( (sum(value_list) / len(value_list) ) , 2 ) )
    if(len(value_list) == 1 ):
        print("\t Standard Deviation: ", 0)
    else:
        print("\t Standard Deviation: ", round(statistics.stdev(value_list), 2))



def load_data(filename):
    areas = []
    values = []
    with open(filename) as f:
        for line in f:
            line = line.replace("\n","")
            areas.append(line.split(",")[0])
            values.append(int(line.split(",")[1]))
    return (areas,values)



if __name__ == "__main__":
    (area_list, value_list) = load_data("data.csv")
    print_overall_stats(value_list)
    print_area_stats(area_list, value_list)
    write_area_measures("Montreal", area_list, value_list)

CODE:

quality.py data.csv import statistics 1 from collections import defaultdict 2 31 def write_area measures (area, area list, value_list) file_name area "data.csv" with open (file_name, 'w') as write file: for area_val, value in zip (area list, value_list): if (area val.strip ) area.strip ()) write file.write (str (value) + "\n") 7 8 9 10 11 def print area stats (area list, value_list) area_dict defaultdict (list) 12 13 14 for area,value in zip (area list, value_1ist): area dict [area].append (value) 15 16 17 for area in area dict.keys print ("\nArea ", area) print_overal1 stats (area_dict [area]) 18 19 20 21 22 def print_overall_stats (value list): print ("Overall Statistics") print ("\t Count: ", len (value_list)) 23 24 25 min (value list) ) max (value_1ist)) print ("\t Maximum: ", 26 27 print ("\t Minimum: ", print ("\t Average: ", round (sum (value 1ist) len (value list), 2 if (len (value_list) 1 28 ) ) 1 ) 29 = print ("\t Standard Deviation: ", 0) 30 else: 31 print ("t Standard Deviation: ", round (statistics.stdev (value list), 2)) 32 33 34 def load_data (filename) 35 areas [l values [ 36 37 with open (filename) as f 38 for line in f line line.replace ("\n","" areas.append (line.split (",") [0]) values.append (int (line.split (",") [1])) 39 40 41 42 return (areas,values) 43 44 if main 45 раme (area list, value_1ist) print overall_stats (value_list) print_area stats (area_list, value list) write_area measures ("Montreal", area_list, value_list) load_data("data.csv") 46 47 48 49

data.csv File

quality.py data.csv Montreal,122 1 Ottawa, 242 Calgary, 182 Montreal, 926 Montreal, 213 Ottawa, 543 Ottawa, 663 7 8 st

Output:

Run: quality C:Anacondalenvs\Pycharm_env\python.exe "C:/Users/Sanchit Kumar/PycharmProjects/untitledl/quality.py" Overall Statistics Count: 7 Maximum: 122 Minimum: 926 Average: 413.0 Standard Deviation 302.72 Area Montreal Overall Statistics Count: 122 Maximum: Minimum: 926 Average 420.33 Standard Deviation: 440.28 Area Ottawa Overall Statistics Count: 3 Maximum: 242 Minimum: 663 Average 482.67 Standard Deviation: 216.89 Area Calgary Overall Statistics Count: 1 Maximum: 182 Minimum: 182 Average: 182.0 Standard Deviation 0 Process finished with exit code 0