# https://data.mos.ru/opendata/893
# https://data.mos.ru/opendata/1251

import json

import openpyxl

wb = openpyxl.load_workbook('sports.xlsx')
sh = wb.active
nmin = sh.cell(row=7, column=2).value
dct = {}
flag = False
for row in sh.rows:
    if not flag:
        flag = True
        continue
    area = row[4].value
    district = row[5].value
    address = row[6].value
    dct.setdefault(area, {})
    dct[area].setdefault(district, [])
    dct[area][district].append(address)

fin = open('sports.json', 'w', encoding='utf-8')
json.dump(dct, fp=fin, ensure_ascii=False)
fin.close()