| import csv | |
| import pathlib | |
| import time | |
| folder = str(pathlib.Path(__file__).parent.resolve()) | |
| def sum_time_by_name(csv_file_path): | |
| time_sums = {} | |
| with open(folder+csv_file_path, mode='r', encoding='utf-8') as csv_file: | |
| csv_reader = csv.reader(csv_file) | |
| next(csv_reader) | |
| for row in csv_reader: | |
| name = row[0].lower() | |
| time_seconds = float(row[3]) | |
| if name not in time_sums.keys(): | |
| time_sums[name] = time_seconds | |
| else: | |
| time_sums[name] += time_seconds | |
| return time_sums | |
| result_A = sum_time_by_name("/Dev_A.csv") | |
| result_B = sum_time_by_name("/Dev_B.csv") | |
| with open(folder+"/Table4.csv", mode='w', newline='', encoding='utf-8') as out_file: | |
| csv_writer = csv.writer(out_file) | |
| for k in result_A.keys(): | |
| csv_writer.writerow(["Dev A", k, round(result_A[k]/3600.0, 2)]) | |
| for k in result_B.keys(): | |
| csv_writer.writerow(["Dev B", k, round(result_B[k]/3600.0, 2)]) |