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