toTreeJson.py

import csv
import json


class Node(object):
    def __init__(self, name, size=None):
        self.name = name
        self.children = []
        self.size = size

    def child(self, cname, size=None):
        child_found = [c for c in self.children if c.name == cname]
        if not child_found:
            _child = Node(cname, size)
            self.children.append(_child)
        else:
            _child = child_found[0]
        return _child

    def as_dict(self):
        res = {'name': self.name}
        if self.size is None:
            res['children'] = [c.as_dict() for c in self.children]
        else:
            res['value'] = self.size
        return res


root = Node('Flare')

with open('adjustedwithValue.csv', encoding="utf8") as f:
    reader = csv.reader(f)
    next(reader)
    for row in reader:
        grp1, grp2, grp3, grp4, size = row
        root.child(grp1).child(grp2).child(grp3).child(grp4, size)

with open('result.json', 'w') as json_file:
    json.dump(root.as_dict(), json_file)