example parse json with recursive

# example parse json with recursive


from typing import Any, Dict
import pandas as pd
import json

path = 'd:\\example1.json'

with open(path, 'r', encoding='utf-8') as file:
    text = file.read()
    data = json.loads(text)


def func(key: str, value: Any, data: Dict) -> None:
    if isinstance(value, list):
        for i in range(len(value)):
            func(f'{key}_{i}', value[i], data)
    elif isinstance(value, dict):
        for k, v in value.items():
            func(f'{key}_{k}', v, data)
    else:
        data[key] = [value]


data_test = {}
for key, value in data.items():
    func(key, value, data_test)

print('finish')
print('count of columns: ', len(data_test))

df = pd.DataFrame.from_dict(data_test)
print(df)