dept_type_to_json.py

"""
This file converts the department_types.csv to .json format with the key being the department name.
Code from https://www.geeksforgeeks.org/convert-csv-to-json-using-python/
"""

import csv 
import json 

def csv_to_json(csvFilePath, jsonFilePath):
    jsonArray = []
      
    #read csv file
    with open(csvFilePath, encoding='utf-8') as csvf: 
        #load csv file data using csv library's dictionary reader
        csvReader = csv.DictReader(csvf) 

        #convert each csv row into python dict
        for row in csvReader: 
            #add this python dict to json array
            jsonArray.append(row)
  
    #convert python jsonArray to JSON String and write to file
    with open(jsonFilePath, 'w', encoding='utf-8') as jsonf: 
        jsonString = json.dumps(jsonArray, indent=4)
        jsonf.write(jsonString)
          
csvFilePath = r'department_types.csv'
jsonFilePath = r'data/department_types.json'
csv_to_json(csvFilePath, jsonFilePath)