json转二维表 python

# -*- coding:utf-8 -*-
import pandas as pd
import re
import json
import ast
from copy import deepcopy
import os
import numpy as np
import warnings
import sys
warnings.filterwarnings("ignore")


def flatten_json(y):
    out = [y]

    def flatten(x, result, name=''):
        if type(x) is dict:
            for a in x:
                flatten(x[a], result, name + a + '_')
        elif type(x) is list:
            result[str(name[:-1])] = x
        else:
            result[str(name[:-1])] = str(x)

    def find_list_key(x):
        for k in x:
            if type(x[k]) is list:
                return k

    done = False
    while not done:
        done = True
        for i in range(len(out)):
            row = out[i]
            result = {}
            flatten(row, result)
            out[i] = result
        for i in reversed(range(len(out))):
            row = out[i]
            list_key = find_list_ke