| 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)]) |
