Несколько массивов JSON для фрейма данных в Python? ⇐ Python

[Anonymous]

У меня есть два типа списка, как показано ниже, и они сохранены в файле .json —
list1 —

Код: Выделить всё

[
[
{
"1": "",
"2": "",
"3": "",
"4": "",
"5": "",
"6": "",
"7": "",
"8": "",
"9": ""
},
{
"1": "Name",
"2": "",
"3": "Country",
"4": "",
"5": "Nature of business",
"6": "",
"7": "Shares held by the Group",
"8": "",
"9": "Shares held by NCI"
},
{
"1": "Directly held interests",
"2": "",
"3": "",
"4": "",
"5": "",
"6": "",
"7": "",
"8": "",
"9": ""
},
{
"1": "Ferrari S.p.A.",
"2": "",
"3": "Italy",
"4": "",
"5": "Manufacturing",
"6": "",
"7": "100%",
"8": "",
"9": "-%"
},
{
"1": "",
"2": "",
"3": "",
"4": "",
"5": "",
"6": "",
"7": "",
"8": "",
"9": ""
},
{
"1": "Indirectly held through Ferrari S.p.A.",
"2": "",
"3": "",
"4": "",
"5": "",
"6": "",
"7": "",
"8": "",
"9": ""
},
{
"1": "Ferrari North America Inc.",
"2": "",
"3": "USA",
"4": "",
"5": "Importer and distributor",
"6": "",
"7": "100%",
"8": "",
"9": "-%"
},
{
"1": "Ferrari Japan KK",
"2": "",
"3": "Japan",
"4": "",
"5": "Importer and distributor",
"6": "",
"7": "100%",
"8": "",
"9": "-%"
},
{
"1": "Ferrari Australasia Pty Limited",
"2": "",
"3": "Australia",
"4": "",
"5": "Importer and distributor",
"6": "",
"7": "100%",
"8": "",
"9": "-%"
},
{
"1": "Ferrari International Cars Trading (Shanghai) Co.  L.t.d.",
"2": "",
"3": "China",
"4": "",
"5": "Importer and distributor",
"6": "",
"7": "80%",
"8": "",
"9": "20%"
},
{
"1": "Ferrari Far East Pte Limited",
"2": "",
"3": "Singapore",
"4": "",
"5": "Service company",
"6": "",
"7": "100%",
"8": "",
"9": "-%"
},
{
"1": "Ferrari Management Consulting (Shanghai) Co. L.t.d.",
"2": "",
"3": "China",
"4": "",
"5": "Service company",
"6": "",
"7": "100%",
"8": "",
"9": "-%"
},
{
"1": "Ferrari South West Europe S.a.r.l.",
"2": "",
"3": "France",
"4": "",
"5": "Service company",
"6": "",
"7": "100%",
"8": "",
"9": "-%"
},
{
"1": "Ferrari Central East Europe GmbH",
"2": "",
"3": "Germany",
"4": "",
"5": "Service company",
"6": "",
"7": "100%",
"8": "",
"9": "-%"
},
{
"1": "G.S.A.  S.A.",
"2": "",
"3": "Switzerland",
"4": "",
"5": "Service company",
"6": "",
"7": "100%",
"8": "",
"9": "-%"
},
{
"1": "Ferrari North Europe L.t.d.",
"2": "",
"3": "UK",
"4": "",
"5": "Service company",
"6": "",
"7": "100%",
"8": "",
"9": "-%"
},
{
"1": "Mugello Circuit S.p.A.",
"2": "",
"3": "Italy",
"4": "",
"5": "Racetrack management",
"6": "",
"7": "100%",
"8": "",
"9": "-%"
},
{
"1": "Ferrari Financial Services S.p.A.",
"2": "",
"3": "Italy",
"4": "",
"5": "Financial services",
"6": "",
"7": "100%",
"8": "",
"9": "-%"
},
{
"1": "",
"2": "",
"3": "",
"4": "",
"5": "",
"6": "",
"7": "",
"8": "",
"9": ""
},
{
"1": "Indirectly held through other Group entities",
"2": "",
"3": "",
"4": "",
"5": "",
"6": "",
"7": "",
"8": "",
"9": ""
}
],
[
{
"1": "(1)",
"2": "Shareholding held by Ferrari Financial Services S.p.A."
}
],
[
{
"1": "(2)",
"2": "Shareholding held by Ferrari North America Inc."
}
]
]

list2-

Код: Выделить всё

[
[
{
"1": "",
"2": ""
},
{
"1": "UNITED STATESName of Subsidiary",
"2": "Jurisdiction of Formation"
},
{
"1": "Alternative Apparel, Inc.",
"2": "Delaware"
},
{
"1": "BA International, L.L.C.",
"2": "Delaware"
},
{
"1": "CC Products LLC",
"2": "Delaware"
},
{
"1": "Ceibena Del, Inc.",
"2": "Delaware"
},
{
"1": "Event 1 LLC",
"2": "Delaware"
},
{
"1": "GearCo LLC",
"2": "Delaware"
},
{
"1": "GFSI Holdings LLC",
"2": "Delaware"
},
{
"1": "GFSI LLC",
"2": "Delaware"
},
{
"1": "GTM Retail, Inc.",
"2": "Kansas"
},
{
"1":  "Hanes El Pedregal Holdings LLC",
"2": "Delaware"
},
{
"1": "Hanes Global Holdings U.S.  Inc.",
"2": "Delaware"
},
{
"1": "Hanes Jiboa Holdings LLC",
"2": "Delaware"
},
{
"1": "Hanes Menswear, LLC",
"2": "Delaware"
},
{
"1": "Hanes Minority Holdings LLC",
"2": "Delaware"
},
{
"1": "Hanesbrands Direct, LLC",
"2": "Colorado"
},
{
"1": "Hanesbrands Export Canada LLC",
"2": "Delaware"
},
{
"1": "HBI Branded Apparel Enterprises, LLC",
"2": "Delaware"
},
{
"1": "HBI Playtex Bath LLC",
"2": "Delaware"
},
{
"1": "HBI Receivables LLC",
"2": "Delaware"
},
{
"1": "HBI Sourcing, LLC",
"2": "Delaware"
},
{
"1": "Inner Self LLC",
"2": "Delaware"
},
{
"1": "It’s Greek To Me, Inc.",
"2": "Kansas"
},
{
"1": "Jasper-Costa Rica, L.L.C.",
"2": "Delaware"
},
{
"1": "Knights Apparel LLC",
"2": "Delaware"
},
{
"1": "Knights Holdco LLC",
"2": "Delaware"
},
{
"1": "Maidenform (Bangladesh) LLC",
"2": "Delaware"
},
{
"1": "Maidenform (Indonesia) LLC",
"2": "Delaware"
},
{
"1": "Maidenform Brands LLC",
"2": "Delaware"
}
],
[
{
"1": "",
"2": ""
},
{
"1": "UNITED STATESName of Subsidiary",
"2": "Jurisdiction of Formation"
},
{
"1": "Maidenform International LLC",
"2": "Delaware"
},
{
"1": "Maidenform LLC",
"2": "Delaware"
},
{
"1": "MF Retail LLC",
"2": "Delaware"
},
{
"1": "Playtex Dorado, LLC",
"2": "Delaware"
},
{
"1": "Playtex Industries, Inc.",
"2": "Delaware"
},
{
"1": "Playtex Marketing Corporation (50% indirectly owned by Hanesbrands Inc.)",
"2": "Delaware"
},
{
"1": "Seamless Textiles, LLC",
"2": "Delaware"
}
],
[
{
"1": "",
"2": ""
},
{
"1": "INTERNATIONALName of Subsidiary",
"2": "Jurisdiction of Formation"
},
{
"1": "Bali Dominicana Inc.",
"2": "Panama"
},
{
"1": "Bali Dominicana Textiles S.A.",
"2": "Panama"
},
{
"1": "BNT Holdco Pty Limited",
"2": "Australia"
},
{
"1":  "Bras N Things Hong Kong Limited",
"2": "Hong Kong"
},
{
"1": "Bras N Things New Zealand Limited",
"2": "New Zealand"
},
{
"1": "Bras N Things Pty Ltd",
"2": "Australia"
},
{
"1": "Bras N Things South Africa (Pty) Ltd",
"2": "South Africa"
},
{
"1": "Canadelle Holding Corporation Limited",
"2": "Canada"
},
{
"1": "Canadelle Limited Partnership",
"2": "Canada"
},
{
"1": "Cartex Manufacturera S. de R. L.",
"2": "Costa Rica"
},
{
"1": "CASA International, LLC Holdings S.C.S.",
"2": "Luxembourg"
},
{
"1": "Caysock, Inc.",
"2": "Cayman Islands"
},
{
"1": "Caytex, Inc.",
"2": "Cayman Islands"
},
{
"1": "Caywear, Inc.",
"2": "Cayman Islands"
},
{
"1": "Ceiba Industrial, S. De R.L.",
"2": "Honduras"
},
{
"1": "Champion (UK) (Champion Products Europe Limited – UK Branch)",
"2": "United Kingdom"
},
{
"1": "Champion Deutschland GmbH",
"2": "Germany"
},
{
"1": "Champion Europe S.r.l.",
"2": "Italy"
},
{
"1": "Champion Europe S.r.l. Greek Branch",
"2": "Greece"
},
{
"1": "Champion Europe S.r.l. Italia Carpi Sucursala Bucuresti (Romanian Branch)",
"2": "Romania"
},
{
"1": "Champion Europe S.r.l. Sucursal en Espana (Spanish Branch)",
"2": "Spain"
},
{
"1": "Champion Europe Services S.r.l.",
"2": "Italy"
},
{
"1": "Champion International Trademarks GmbH (Champion International Trademarks S.a r.l.)",
"2": "Switzerland"
},
{
"1": "Champion Northern Europe (Champion Products Europe Limited – Norwegian Branch)",
"2": "Norway"
},
{
"1": "Champion Northern Europe, Branch (Champon Products Europe Limited – Swedish Branch)",
"2": "Sweden"
},
{
"1": "Champion Product SRL",
"2": "Romania"
}
]]

list1 прост, и на его основе легко создать фрейм данных. Для создания фрейма данных я использовал приведенный ниже код —

Код: Выделить всё

f = open('data.json',encoding='utf-8')

data = json.load(f)

dd = data[0]
df = pd.DataFrame(data)
header_row = df.iloc[1]
df1 = pd.DataFrame(df.values[2:], columns=header_row)

Но можем ли мы создать фрейм данных из вложенного массива list2, внеся изменения в приведенный выше код или любой общий код, который может справиться с обеими ситуациями?
Пожалуйста, помогите.

Подробнее здесь: https://stackoverflow.com/questions/787 ... -in-python