File size: 1,000 Bytes
81b9afd 0cea2c9 81b9afd |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
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)]) |