在python中使用csv格式的列表转换json

Question

我想将json文件转换为csv（然后是Excel）。 我的json文件示例：

{
    "populaires": {
        "perfo_indice": {
            "perfo_indice_annual": {
                "perfo_indice_annual_value": 100.96,
                "perfo_percentage_annual_value": 0.96
            },
            "perfo_indice_monthly": {
                "perfo_percentage_monthly_value": 0.96
            }
        },
        "modeles": [
            {
                "marque": "Austin",
                "modele": "Mini",
                "cote": {
                    "cote_2020": 13553,
                },
                "perfo_modeles": {
                    "perfo_modeles_annual": {
                        "perfo_modeles_indice_annual_value": 101.87,
                        "perfo_modeles_percentage_annual_value": 1.87
                    },
                    "perfo_modeles_monthly": {
                        "perfo_modeles_percentage_monthly_value": 1.87
                    }
                }
            },
            {
                "marque": "Citroën",
                "modele": "2CV",
                "cote": {
                    "cote_2020": 11157,
                },
                "perfo_modeles": {
                    "perfo_modeles_annual": {
                        "perfo_modeles_indice_annual_value": 101.92,
                        "perfo_modeles_percentage_annual_value": 1.92
                    },
                    "perfo_modeles_monthly": {
                        "perfo_modeles_percentage_monthly_value": 1.92
                    }
                }
            }]
    }]

Id'希望输出只包含带值的键，例如：populaires, perfo_indice_annual_value, perfo_percentage_annual_value, perfo_percentage_monthly_value, marque，等等

我有300英镑

我试着用一个：

with open('./json/indice_na_2021-01-20.json', encoding='utf-8') as data_model:
data = json.loads(data_model.read())

pt_data1 = open('pt_data1.csv', 'w')
csvwriter = csv.writer(pt_data1)
count = 0

for pt in data:
    if count == 0:
            header = pt.keys()
            csvwriter.writerow(header)
            count += 1
    csvwriter.writerow(pt.values())
pt_data1.close()

但是.csv只是显示了列表

如何通过“modele”创建一个csv文件，其中包含所有具有值的键

Answer 1

我建议您一次提取一个所需的键，并一次构造每一行。例如：

import json
import csv


with open('indice_na_2021-01-20.json', encoding='utf-8') as data_model:
    data = json.load(data_model)

with open('pt_data1.csv', 'w', newline='', encoding='utf-8') as pt_data1:
    csvwriter = csv.writer(pt_data1)
    csvwriter.writerow(["marque", "modele", "perfo_modeles_indice_annual_value", "perfo_modeles_percentage_annual_value"])
    
    for model in data["populaires"]["modeles"]:
        marque = model["marque"]
        modele = model["modele"]
        perfo_modeles_indice_annual_value = model["perfo_modeles"]["perfo_modeles_annual"]["perfo_modeles_indice_annual_value"]
        perfo_modeles_percentage_annual_value = model["perfo_modeles"]["perfo_modeles_annual"]["perfo_modeles_percentage_annual_value"]
        
        csvwriter.writerow([marque, modele, perfo_modeles_indice_annual_value, perfo_modeles_percentage_annual_value])

这将为您提供以下数据：

marque,modele,perfo_modeles_indice_annual_value,perfo_modeles_percentage_annual_value
Austin,Mini,101.87,1.87
Citroën,2CV,101.92,1.92