如何将字典项与嵌套列表分开

Question

我陷入了一个项目，我必须从列表中分离所有字典项目并从中创建一个数据框。下面是 json 文件链接。

链接：- https://drive.google.com/file/d /1H76rjDEZweVGzPcziT5Z6zXqzOSmVZQd/view?usp=sharing

我编写了这段代码，将所有列表项转换为字符串。因此我可以将它们分成一个新列表。然而，收集的项目并没有被隐藏到数据框中。我们将非常感谢您的帮助。

     read_cont = []
new_list1 = []
new_list2 = []

     for i in rjson:
for j in rjson[i]:
read_cont.append(rjson[i][j])

      data_filter = read_cont[1]
      for item in data_filter:
      for j in item:
            new_list1.append(item[j])
    
    
      new_list1 =  map(str,new_list1)
    
     for i in new_list1:
        if len(i) > 100:
             new_list2.append(i)
    
        header_names = ["STRIKE PRICE","EXPIRY","underlying", "identifier","OPENINTEREST","changeinOpenInterest","pchangeinOpenInterest", "totalTradedVolume","impliedVolatility","lastPrice","change","pChange", "totalBuyQuantity","totalSellQuantity","bidQty","bidprice","askQty","askPrice","underlyingValue"]
        df = pd.DataFrame(new_list2,columns=header_names)`

它应该看起来像这样............

Columns: [STRIKE PRICE, EXPIRY, underlying, identifier, OPENINTEREST, changeinOpenInterest, pchangeinOpenInterest, totalTradedVolume, impliedVolatility, lastPrice, change, pChange, totalBuyQuantity, totalSellQuantity, bidQty, bidprice, askQty, askPrice, underlyingValue]
Index: []

Answer 1

import json
import pandas as pd

h = json.load(open('scrap.json'))

mdf = pd.DataFrame()
for i in h['records']['data']:
    for k in i:
        if isinstance(i[k], dict):
            df = pd.DataFrame(i[k], index=[0])
            mdf = pd.concat([mdf, df])
            continue
print(mdf)