generate_report.py

#!/usr/bin/env python3

import csv


def read_employees(csv_file_location):
    with open(csv_file_location) as csv_file:
        csv.register_dialect('empDialect', skipinitialspace=True, strict=True)
        csv_reader = csv.DictReader(csv_file, dialect='empDialect')
        employee_list = []
        for data in csv_reader:
            employee_list.append(data)

        return employee_list


employee_list = read_employees(
    "/home/student-04-25f29a151feb/data/employees.csv")


def process_data(employee_list):
    department_list = []
    for employee_data in employee_list:
        department_list.append(employee_data["Department"])

    department_data = {}
    for department_name in set(department_list):
        department_data[department_name] = department_list.count(
            department_name)

    return department_data


dictionary = process_data(employee_list)
print(dictionary)


def write_report(dictionary, report_file):
    with open(report_file, 'w+') as f:
        for k in sorted(dictionary):
            f.write(str(k)+':'+str(dictionary[k])+'\n')
        f.close()


write_report(dictionary, "/home/student-04-25f29a151feb/test_report.txt")