python中嵌套Json的json到csv的转换

Question

具有以下json格式的数据

{"A": {"Show only": ["Buy"], "Apple MacBook Product Line": ["MacBook Pro", "MacBook Air", "MacBook (Original)"], "Color": ["Space Gray", "Silver", "Gold", "Rose Gold", "Gray", "White", "Champagne Gold"], "Seller": ["Back Market", "Best Buy", "eBay"]}, "B": {"Show only": ["Buy"], "Material": ["Human Hair", "Synthetic"], "Features": ["Lace Front"], "Seller": ["arabellahair", "Ergode", "PartyBell.com"]}}

已尝试使用下面的代码将其转换为csv格式

import pandas as pd
import csv
import glob


for file in glob.glob('file.json'):
    dfjson = pd.read_json(file,encoding='utf-8',lines= False, dtype=str)
dfjson.to_csv("output.csv",index = True)

但是预期的输出是

A   Show only   Buy
A   Apple MacBook Product Line_001  MacBook Pro
A   Apple MacBook Product Line_002  MacBook Air
A   Apple MacBook Product Line_003  MacBook (Original)
A   Color_001   Space Gray
A   Color_002   Silver
A   Color_003   Gold
A   Color_004   Rose Gold
A   Color_005   Gray
A   Color_006   White
A   Color_007   Champagne Gold
A   Seller_001  Back Market
A   Seller_002   Best Buy
A   Seller_003  eBay
B   Show only   Buy
B   Material_001    Human Hair
B   Material_002    Synthetic
B   Features    Lace Front
B   Seller_001  arabellahair
B   Seller_002  Ergode
B   Seller_003  PartyBell.com

要获得此输出，可以进行哪些更改

Answer 1

你弄错了json结构，这里我试着用正确的格式替换你的json。

json_file =  {"col1" :["A" , "A" , "A"] ,
              "col2": ["Show only" ,"Apple MacBook Product" ,"Apple MacBook Product"],
              "col3":["Buy","MacBook Pro","MacBook (Original)" ]}

df = pd.DataFrame(json_file)

df

    col1    col2           col3
0   A       Show only      Buy
1   A       Apple MacBook  Product  MacBook Pro
2   A       Apple MacBook  Product  MacBook (Original)