json-formatting.py

import csv
import json

def make_json(csvFilePath, jsonFilePath):
    # create a dictionary
    data = {}

    # Open a csv reader called DictReader
    with open(csvFilePath, encoding='utf-8') as csvf:
        csvReader = csv.DictReader(csvf, delimiter=';')

        # Convert each row into a dictionary
        # and add it to data
        for rows in csvReader:
            # Assuming a column named 'ID' to
            # be the primary key
            key = rows['\ufeffID']
            data[key] = rows

    # Open a json writer, and use the json.dumps()
    # function to dump data
    with open(jsonFilePath, 'w', encoding='utf-8') as jsonf:
        jsonf.write(json.dumps(data, indent=4))

# Decide the two file paths according to your
# computer system
csvFilePath = "data/LitOnderzoek.csv"
jsonFilePath = "data/QandAData.json"

# Call the make_json function
make_json(csvFilePath, jsonFilePath)