xlsx to json

excel_to_json.py

# -*- coding: utf-8 -*-

"""将excel转换成json"""

import json
import pandas
import numpy

courts = pandas.read_excel("courts.xlsx")

name_mapping = {}

for court in courts.iterrows():
    stand_name = ""
    for value in court[1]:
        if not stand_name:
            stand_name = value
        names = name_mapping.setdefault(stand_name, [])
        if not pandas.isnull(value):
            names.append(value)

print(json.dumps(name_mapping, indent=2, ensure_ascii=False))