Excel to dict

script.py

import json
import pandas as pd

from collections import defaultdict

multi_depth_defaultdict = lambda: defaultdict(multi_depth_defaultdict)

df = pd.read_excel('category.xlsx')

data = multi_depth_defaultdict()

for idx, df_data in df.iterrows():
    d1, d2, d3, d4 = [_.strip() for _ in df_data]
    data[d1][d2][d3] = d4

with open('category_dump.json', 'w') as f:
    json.dump(data, f)