嵌套 JSON 到 CSV(多级)

如果你的JSON数据集固定长度，你可以解决这个问题，我希望这个代码能正常工作.沿着这条路走..(JSON到词典，再到CSV使用Pandas ).

# import pandas
import pandas as pd

# Read JSON file
df = pd.read_json('C://Users//jahir//Desktop//json_file.json')

# create dictionary
create_dict = {} 

# Iteration JSON file
for index,values in df.iterrows():
    
    # for loop ext_line_items
    for ext_lines in df['ext_line_items'][index]:
        for item in ext_lines:
            column_name = 'ext_line_items_'+item
            if column_name not in create_dict:
                create_dict[column_name] =[]
            
            # four time for to create four product ext_line_items_key_0, ext_line_items_key_1, ext_line_items_key_4
            time_loop = 4
            while time_loop > 0:
                time_loop-=1
                create_dict[column_name]+=[ext_lines[item]]
    
    # for loop ext_prix dataset
    # four time for to create four product ext_prix_key_0
    time_loop = 4
    while time_loop > 0:
        time_loop-=1
        for ext_prix in df['ext_prix'][index]:
            for item in ext_prix:
                column_name = 'ext_prix_'+item
                if column_name not in create_dict:
                    create_dict[column_name] =[]
                create_dict[column_name]+=[ext_prix[item]]
    # add key in dictionary 
    for i in ['id', 'ext_numero_commande', 'ext_tag', 'ext_jour_livraison']:
        create_dict[i]=[]
        
    
    # 16 time for to create 4*4 product 'id', 'ext_numero_commande', 'ext_tag', 'ext_jour_livraison'
    total_time = 16
    while total_time > 0:
        total_time-=1
        for j in ['id', 'ext_numero_commande', 'ext_tag', 'ext_jour_livraison']:
            create_dict[j] += [df[j][index]]

# Dictionary to DataFrame
pd_dict= pd.DataFrame.from_dict(create_dict) 

# DataFrame to write csv file
write_csv_path = 'C://Users//jahir//Desktop//csv_file.csv'
pd_dict.to_csv(write_csv_path, index = False, header = True)

输出: